RE: Offshore protests + Idle events (to keep it On-track!)

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Tue, 23 Sep 2003 10:29:42 -0800
Message-ID: <F001.005D0D7D.20030923102942@fatcity.com>

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).

Received on Tue Sep 23 2003 - 13:29:42 CDT