Home » RDBMS Server » Performance Tuning » how to change snapshot timings
how to change snapshot timings [message #152614] Sun, 25 December 2005 08:09 Go to next message
Messages: 34
Registered: April 2005
Location: chennai

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
Re: how to change snapshot timings [message #152698 is a reply to message #152614] Mon, 26 December 2005 11:11 Go to previous message
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 ..


that should work ..

-Sai Jeedigunta
Previous Topic: Tuning of Select for a View in Report
Next Topic: Interview Qstns
Goto Forum:

Current Time: Tue Dec 06 21:14:00 CST 2022