| Performance Tuning Tool [message #166523] |
Thu, 06 April 2006 18:26  |
suryamz
Messages: 17
Registered: March 2006
|
Junior Member |
|
|
Hi
We have 8i/Win NT.
It was noticed the statspack that was installed earlier on our Prod Server is been corrupted.
I read about un-installing statspack using spdrop.sql
1) Is it safe to run this script on PDB in order to un-install and reinstall statspack. ? or would be any impact on our current PDB due to this ?
2) If thats true, then can i go ahead and pick the stats using BSTAT and ESTAT (for this what is the ideal time that i should give between these scripts)
and are any more built-in scripts that i can use to get the performace details apart from running statspack
Thanks
surya.
[Updated on: Thu, 06 April 2006 18:28] Report message to a moderator |
|
|
|
| Re: Performance Tuning Tool [message #166609 is a reply to message #166523] |
Fri, 07 April 2006 03:55  |
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
|
Member |
|
|
what is the current tablespace that is residing, imo it is perfectly ok to run drop script (but before doing that check what it is exactly doing in the script)
Thanks
Madhu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
