RE: Anyone using statspack? (new for 8.1.6+ only)

Hi Steve,

On the timed_statistics issue, the overhead is tiny - much less than 1%. You can check using the SQL*Plus SET TIMING ON command for a benchmark query, but of course you need to ignore the first result for each test. On many platforms and for many tests the difference is not statistically significant. On NT I consistently get slightly worse performance with timed_statistics off !

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Steve Orr [SMTP:sorr_at_arzoo.com]
Sent:	Thursday, May 11, 2000 4:29 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Anyone using statspack? (new for 8.1.6+ only)

Anyone using the new statspack which became available as of 8.1.6? It looks like a worthy replacement for bstat/estat. (See the files matching $ORACLE_HOME/rdbms/admin/stats*.) It provides a sample DBMS_JOB to gather stats every hour on the hour but to do this properly they want you to have timed_statistics = TRUE all the time.

What are the pros/cons of having timed_statistics permanently turned on? I know some of the 3rd party monitoring tools want it on all the time. I'm thinking about collecting "performance snapshots" on a periodic basis with cron so I can toggle timed_statistics on/off.

Any recommendations or feedback on timed_statistics?

Anyone enthused about or have feedback on statspack?

Statspack was covered in the March/April issue of Oracle Magazine.

Steve Orr

-- 
Author: Steve Orr
  INET: sorr_at_arzoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).