Home » RDBMS Server » Performance Tuning » Performance Tuning Tool
Performance Tuning Tool [message #166523] Thu, 06 April 2006 18:26 Go to next message
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 Go to previous message
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
Previous Topic: Is it Oracle 10g slower comparatively Oracle 9i
Next Topic: migrating SYS from DICT to LOCAL
Goto Forum:
  


Current Time: Fri Mar 29 02:50:51 CDT 2024