RE: PERFSTAT schema and STATPACK in 11.1

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_at_freelists.org on behalf of K Gopalakrishnan Sent: Mon 05/04/2010 20:30
To: lyallbarbour_at_sanfranmail.com
Cc: oracle-l_at_freelists.org
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_at_sanfranmail.com> 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





--
http://www.freelists.org/webpage/oracle-l