Search This Blog

Total Pageviews

Wednesday, 3 August 2011

Oracle 11g adrci purge

Oracle adrci purge

adrci purge


7days

1hr=60 minutes
1day = 24 hr
1 week =7 days

select 60*24*7 week_to_min from dual;

60*24*7
----------
10080 <<<------- min




oracle_sid=aptdb

adrci> set home aptdb
adrci> purge -age 10080 -type ALERT
adrci> purge -age 10080 -type TRACE
adrci> purge -age 10080 -type incident
adrci> purge -age 10080 -type hm
adrci> purge -age 10080 -type utscdmp
adrci> purge -age 10080 -type cdump



to set auto purge

select 168/7 from dual;

168/7
----------
24 ----- hr

168 is hr

adrci>set control (SHORTP_POLICY = 168) now set to 7 days
adrci>set control (LONGP_POLICY = 168 now set to 7 days

No comments:

Oracle DBA

anuj blog Archive