Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine system load?
In article <8lroen$4ujkl$1_at_ID-6634.news.cis.dfn.de>,
hennes_at_topmail.de wrote:
> Hi,
>
> I have to write a PL/SQL procedure (periodically invoked by DBMS_JOB)
> which reads the current system CPU load of the server and reports this
> together with a time stamp into a log table.
> Any ideas how to get the load? I tried V$SYSSTAT Parameter 11 and 12
> but their values are allways 0.
>
> Many thanks in advance
> Ralf Jonas
>
Verify your timed_statistics parameter. Most likely it is false. It
needs to be true! Change the init<sid>.ora and bounce the database.
The overhead incurred by using timed_statistics is minimal.
Hth,
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Jul 28 2000 - 00:00:00 CDT
![]() |
![]() |