RE: PERFSTAT schema and STATPACK in 11.1
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <kaygopal@xxxxxxxxx>, <lyallbarbour@xxxxxxxxxxxxxxx>
- Date: Tue, 6 Apr 2010 11:55:02 +0100
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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
