Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to determine system load?

Re: How to determine system load?

From: <sybrandb_at_my-deja.com>
Date: 2000/07/28
Message-ID: <8lrueg$bql$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US