Home » RDBMS Server » Performance Tuning » STATSPACK question on 10g and 8i
STATSPACK question on 10g and 8i [message #183395] Thu, 20 July 2006 13:36 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
I have statspack question for both database 10g and 8i

a. How do I see if statspack is installed
b. If it is there how do I change the time interval to be an hour.

Thanks
Toshi
Re: STATSPACK question on 10g and 8i [message #184064 is a reply to message #183395] Tue, 25 July 2006 03:10 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
a) Query DBA_OBJECTS to see if the staspack tables exist on your database.

b) Look at the spauto.sql script in OH/rdbms/admin.
Re: STATSPACK question on 10g and 8i [message #188861 is a reply to message #183395] Tue, 22 August 2006 03:36 Go to previous message
alexdabr
Messages: 1
Registered: August 2006
Junior Member
Hi,

You can simply query ALL_USERS view to see whether the user PERFSTAT exists. If it does, the you have STATSPACK schema installed in your database.
Previous Topic: Does execution plan depend on Client / Client-platform ?
Next Topic: Temp segment issue
Goto Forum:
  


Current Time: Fri Dec 09 19:18:29 CST 2016

Total time taken to generate the page: 0.11399 seconds