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

Steve,

Check out http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html if you haven't already seen it. It is an article on StatsPack.

As for having timed_statistics=true, the overhead is negligible.

I turn it on in all databases.

Jared

On Wed, 10 May 2000, Steve Orr wrote:

> 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
>
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue May 16 2000 - 10:57:05 CDT