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

Home -> Community -> Usenet -> c.d.o.server -> Re: Use of statspack in a pl/sql procedure

Re: Use of statspack in a pl/sql procedure

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 01 Aug 2004 22:41:25 -0700
Message-ID: <1091425318.703243@yasure>


Paul Drake wrote:

> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1091079046.326109_at_yasure>...
>

>>sybrandb_at_yahoo.com wrote:
>>
>>
>>>matthieu.atkinson_at_eu.altria.com (Matt) wrote in message news:<f683f010.0407280157.61f40dfe_at_posting.google.com>...
>>
>>>You are aware statspack maintains history in the perfstat schema?
>>>What are you trying to accomplish? Are you sure you are not trying to
>>>reinvent the wheel?
>>>
>>
>>And if you are on 10g why use stats pack anymore?
>>Take a look at: http://www.psoug.org/reference/awr.html

>
>
> not everyone is running Enterprise Edition for all of their 10g databases.
> for those that don't, AWR is literally not an option.
>
> -bdbafh

I know that. But many are or soon will be. And AWR is far superior to the old Stats Pack.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Aug 02 2004 - 00:41:25 CDT

Original text of this message

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