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

Report message to a moderator

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: 4596
Registered: April 1998
Senior Member
Read this post -
http://www.orafaq.com/maillist/oracle-l/2002/08/10/0930.htm

Best regards.

Frank

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 29 04:16:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.