Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Anyone using statspack? (new for 8.1.6+ only)

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

From: Marina Leonardo, Jose Luis <JLMarina_at_Uni2.es>
Date: Thu, 11 May 2000 15:10:29 +0200
Message-Id: <10494.105371@fatcity.com>


Hi,

1.- No, I havent used yet the new package. I´m still using utlbstat/utlestat.

2.- I have two DB on two very crowded Sparc Server, with timed_statistics=TRUE all the time.
I´ve experienced no problem, nor performamce degradation

HTH


> -----Mensaje original-----
> De: Steve Orr [SMTP:sorr_at_arzoo.com]
> Enviado el: jueves 11 de mayo de 2000 8:29
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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).
Received on Thu May 11 2000 - 08:10:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US