Re: How to determine system load?

And the next time he bounces the database he will loose the alteration if he didn't modify init.ora!

Regards,

Sybrand Bakker, Oracle DBA

"Yong" <yhuang_at_slb.com> wrote in message news:8lse5l$sir$1_at_news.sinet.slb.com...
> 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