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.