RE: PERFSTAT schema and STATPACK in 11.1

Lyall,
 
Documentation for Statspack can be found at following location 
$ORACLE_HOME/rdbms/admin/spdoc.txt
 
spdrop.sql file is also stored in $ORACLE_HOME/rdbms/admin folder. 
 
 
Regards,
Vishal Gupta
http://www.vishalgupta.com   

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of K Gopalakrishnan
Sent: Mon 05/04/2010 20:30
To: lyallbarbour@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: PERFSTAT schema and STATPACK in 11.1



Lyall.,

Look for spdrop.sql.

-Gopal



On Mon, Apr 5, 2010 at 2:26 PM,  <lyallbarbour@xxxxxxxxxxxxxxx> wrote:
> Now that we are upgrading everything 11g, and we are using Grid, we do not
> need STATPACK anymore.  AWR is running on schedule and everything is being
> evaluated and monitored that way.
> Can i simply drop the PERFSTAT user to be rid of this stuff, or is there an
> uninstall script?  I have been looking through Metalink, but i haven't seen
> a doc about that, just about how to fix it if it's broken from an upgrade.
> Thanks,
> Lyall
>
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: