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
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
Re: how to change snapshot timings [message #152698 is a reply to message #152614] Mon, 26 December 2005 11:11 Go to previous message
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
Previous Topic: Tuning of Select for a View in Report
Next Topic: Interview Qstns
Goto Forum:
  


Current Time: Fri Mar 29 04:32:59 CDT 2024