I remove from this table the events deemed not idle for the database and Application supported by
it. SQL*Net message related events can be important in client/server type environments.
HTH,
- Kirti
- Stephane Paquette <stephane.paquette_at_standardlife.ca> wrote:
> Can you elaborate on fixing the STATS$IDLE_EVENT table.
>
> Thanks
>
>
> Stephane Paquette
> Administrateur de bases de donnees
> Database Administrator
> Standard Life
> www.standardlife.ca
> Tel. (514) 499-7999 7470 and (514) 925-7187
> stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>
>
>
>
> -----Original Message-----
> Kirtikumar Deshpande
> Sent: Tuesday, September 23, 2003 2:15 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If I install statspack, I always 'fix' the STATS$IDLE_EVENT table, and also
> change the varibale
> top_n_events to 10 (from 5) in spreport.sql. Statspack is a very generic
> tool. One must 'tune' it
> to reflect ones environment...
>
> :)
>
> - Kirti
>
> --- John Kanagaraj <john.kanagaraj_at_hds.com> wrote:
> > Dan,
> >
> > You said that very well (as usual). The problem is that Management doesn't
> > usually see the downside of their downsizing actions until the stuff hits
> > the fan. And Larry's statements about self-tuning databases are not
> helping
> > as well - they help apply pressure on a dwindling market, whether real or
> > apparent. The ability to communicate complex problems in simple, everyday
> > language will _always_ stand you in good stead - whether to the business,
> to
> > management or your fellow workers. I recently replied patiently without
> > sarcasm to a question on an internal Java user group about why compiling
> > procedures/packages when users are online is a bad idea - I could have
> been
> > rude and told the largerly development audience off. The VP of Development
> > was on that list (I didn't know about this) and wrote me a nice
> > complimentary note. I hope to stand well when there is a shake-up later on
> > :)
> >
> > On Idle events - I had a situation previously when I was remotely
> diagnosing
> > a performance issue and noticed a large number of PQ related "idle"
> events.
> > Turns out that the DBA had switched on PQ to make the queries 'run
> faster' -
> > the two CPU server was just choked to death after this. These 'idle'
> events
> > from a Statspack report helped me solve the issue (turn off PQ on all
> tables
> > - it was an OLTP system).
> >
> > John Kanagaraj
> > DB Soft Inc
> > Phone: 408-970-7002 (W)
> >
> > Listen to great, commercial-free christian music 24x7x365 at
> > http://www.klove.com
> >
> > ** The opinions and facts contained in this message are entirely mine and
> do
> > not reflect those of my employer or customers **
> >
> >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: kirtikumar_deshpande_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Paquette
> INET: stephane.paquette_at_standardlife.ca
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
INET: kirtikumar_deshpande_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 23 2003 - 13:44:51 CDT
