Home » RDBMS Server » Performance Tuning » automatic statspack
automatic statspack [message #241369] Tue, 29 May 2007 06:44 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

hi

can annybody tell me how to statspack snaps automatically at some time or every hour
i have some idea that spauto.sql is responsible for this but how can we implemaent it ( oracle9i)
Re: automatic statspack [message #241380 is a reply to message #241369] Tue, 29 May 2007 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why do you mean how to implement it?
How to create statspack user and tables? execute spcreate.sql
How to spawn the job? execute spauto.sql

Regards
Michel
Re: automatic statspack [message #241936 is a reply to message #241369] Thu, 31 May 2007 02:10 Go to previous message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

You may look at this doc, section Changing the Interval of Statistics Collection

Hope this works.

Brayan
Previous Topic: HWM in table
Next Topic: PARTITION HELP
Goto Forum:
  


Current Time: Tue Dec 03 07:44:51 CST 2024