OraFAQ Forum: Performance Tuning » automatic statspack

Home » RDBMS Server » Performance Tuning » automatic statspack

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

automatic statspack [message #241369]

Tue, 29 May 2007 06:44

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)

Report message to a moderator

Re: automatic statspack [message #241380 is a reply to message #241369]

Tue, 29 May 2007 07:23

Michel Cadot
Messages: 68770
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

Report message to a moderator

Re: automatic statspack [message #241936 is a reply to message #241369]

Thu, 31 May 2007 02:10

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

Report message to a moderator

Previous Topic:	HWM in table
Next Topic:	PARTITION HELP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 02 06:56:27 CDT 2025