Hi,
Statspack can be used on 8.1.5 also.
I'm using it since a couple of weeks.
There is a tip on oramag, march issue, to install it
on 8.1.5. Basically, you need to create a new view
then you follow the statspack install.
Do not used timed_statistics on 8.1.5, it prevents
Oracle to shared cached cursor (bug 1210242).
So far I'm using statspack without timed_statistics
and I do not see what i'm losing. I've called Oracle
tech support and the guy I spoke too (from the tuning
and performance group) has never used statspack !
- Steve Adams <steve.adams_at_ixora.com.au> a icrit : >
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).
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Received on Fri May 12 2000 - 03:06:30 CDT
