RE: Stats Pack

Hi,

I will be giving a presentation on STATSPACK at OOW. The utility is pretty easy to use. There doesn't seem to be a lot of documentation on it, but there are some good papers out on metalink (check technet also).

I personally like it, and have also talked with some DBA's that have been using it in a production environment for months and swear by it...

I agree with Vincent though, Oracle did not provide an good way to delete old records, or snapshot. You really have to monitor your datafile growth depending on how much you use the utility.

Susan McClain
Manager, Oracle DBA
marchFIRST

----Original Message Follows----
From: Hatzistavrou Giannis <j.hatzistavrou_at_telesoft.gr> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: Stats Pack
Date: Fri, 22 Sep 2000 05:05:51 -0800

Dear Vincent,

May you please send to mt personnal email Part1 and Part2.pdf files.

Thanks

> -----Original Message-----
> From: Vincent Ruger [SMTP:Vincent.Ruger_at_nos.nl]
> Sent: Paqasjeu^, 22 Septelbq_ou 2000 11:42 pl
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Stats Pack
>
> Dave,
>
> A few articals on statspack.
> Unfortunatly there's no script yet to get rid of old snapshots.
>
> hth
>
> Vincent Ruger
> (Oracle DBA)
>
> -----Oorspronkelijk bericht-----
> Van: root_at_fatcity.com [ <mailto:root_at_fatcity.com>]Namens David Turner
> Verzonden: vrijdag 22 september 2000 0:16
> Aan: Multiple recipients of list ORACLE-L
> Onderwerp: Stats Pack
>
>
> Anyone have a good link to info on the Stats Pack?
>
>
> Thanks, Dave Turner
> --
> Please see the official ORACLE-L FAQ: <http://www.orafaq.com>
> --
> Author: David Turner
> INET: turner_at_tellme.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).
>
> << File: part1.pdf >> << File: ReadMe.txt >> << File: part2.pdf
> >>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hatzistavrou Giannis
   INET: j.hatzistavrou_at_telesoft.gr

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

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at