OraFAQ Forum: Performance Tuning » STATSPACK question on 10g and 8i

Home » RDBMS Server » Performance Tuning » STATSPACK question on 10g and 8i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

STATSPACK question on 10g and 8i [message #183395]

Thu, 20 July 2006 13:36

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

Report message to a moderator

Re: STATSPACK question on 10g and 8i [message #184064 is a reply to message #183395]

Tue, 25 July 2006 03:10

Frank Naude
Messages: 4579
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.

Report message to a moderator

Re: STATSPACK question on 10g and 8i [message #188861 is a reply to message #183395]

Tue, 22 August 2006 03:36

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.

Report message to a moderator

Previous Topic:	Does execution plan depend on Client / Client-platform ?
Next Topic:	Temp segment issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 09:00:42 CDT 2024