Home » RDBMS Server » Performance Tuning » automate spurge.sql job
automate spurge.sql job [message #64895] Fri, 27 February 2004 07:22 Go to next message
Tjan
Messages: 2
Registered: February 2004
Junior Member
Has anyone automate a purge process for the statspack Id. I have dbms job that create stastpack every hour. But I need to automate the purge job to delete all the id that are older than a month. Thanks
Re: automate spurge.sql job [message #64897 is a reply to message #64895] Sat, 28 February 2004 23:24 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Read this post -
http://www.orafaq.com/maillist/oracle-l/2002/08/10/0930.htm

Best regards.

Frank
Previous Topic: optimizing query - taking way too long to run
Next Topic: Oracle 9i optimizer
Goto Forum:
  


Current Time: Fri Mar 29 09:41:41 CDT 2024