OraFAQ Forum: Performance Tuning » how to change snapshot timings

Home » RDBMS Server » Performance Tuning » how to change snapshot timings

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

how to change snapshot timings [message #152614]

Sun, 25 December 2005 08:09

ravivkumar
Messages: 34
Registered: April 2005
Location: chennai

Member

hi
As i am started to run the snapshot inorder to generate statspack report , by default it is set to one hour , how to change the time inorder to take snapshot within a period of 3 minutes.

Thanks and Regards
Ravikumar.V

Report message to a moderator

Re: how to change snapshot timings [message #152698 is a reply to message #152614]

Mon, 26 December 2005 11:11

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

create a dbms job with an interval of 3 minutes

'SYSDATE + 3/1440'

and put the below in the what condition ..

 
statspack.snap;

that should work ..

-Sai Jeedigunta

Report message to a moderator

Previous Topic:	Tuning of Select for a View in Report
Next Topic:	Interview Qstns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 07:37:06 CST 2024