Re: Use of statspack in a pl/sql procedure

From: Paul Drake <bdbafh_at_gmail.com>
Date: 30 Jul 2004 06:19:37 -0700
Message-ID: <910046b4.0407300519.4120b6ab@posting.google.com>

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 Received on Fri Jul 30 2004 - 08:19:37 CDT