Home » RDBMS Server » Server Administration » Purge logs ( oracle10g, solaris)
Purge logs [message #338375] Mon, 04 August 2008 15:20 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Hi all,

doc says

The Scheduler automatically purges all log entries from both the job log and the window log that are older than the history you specify. It does this once a day, and the default is 30 days.


can anybody tell me how to find out the days specify to purge all job entries from both job and window log ?( where default is 30days)
Re: Purge logs [message #338388 is a reply to message #338375] Mon, 04 August 2008 17:05 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can see the current value with one or both of the following:

select * from ALL_SCHEDULER_GLOBAL_ATTRIBUTE;
select job_class_name, log_history from ALL_SCHEDULER_JOB_CLASSES;

You can set a value globally with:

DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE('log_history','<new_value>');

or for a certain class:

DBMS_SCHEDULER.SET_ATTRIBUTE('<class_name>','log_history','<new_value>');

Re: Purge logs [message #338390 is a reply to message #338388] Mon, 04 August 2008 17:13 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thank you ebrian

[Updated on: Mon, 04 August 2008 17:14]

Report message to a moderator

Previous Topic: Moving objects to a new tablespace
Next Topic: Change the partition type online
Goto Forum:
  


Current Time: Sun Dec 04 16:30:49 CST 2016

Total time taken to generate the page: 0.09555 seconds