Re: How to determine system load?

From: Yong <yhuang_at_slb.com>
Date: 2000/07/28
Message-ID: <8lse5l$sir$1@news.sinet.slb.com>#1/1

If he doesn't want to bounce the database, he can alter system and it will take effect immediately. Look at this:

SQL> select issys_modifiable from v$parameter where name = 'timed_statistics';

ISSYS_MOD

---

IMMEDIATE Yong Huang

<sybrandb_at_my-deja.com> wrote in message news:8lrueg$bql$1_at_nnrp1.deja.com...
> 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