OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Purge logs ( oracle10g, solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Purge logs [message #338375]

Mon, 04 August 2008 15:20

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)

Report message to a moderator

Re: Purge logs [message #338388 is a reply to message #338375]

Mon, 04 August 2008 17:05

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>');

Report message to a moderator

Re: Purge logs [message #338390 is a reply to message #338388]

Mon, 04 August 2008 17:13

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 16:03:18 CDT 2024