{"id":456,"date":"2014-06-20T08:21:55","date_gmt":"2014-06-20T06:21:55","guid":{"rendered":"http:\/\/www.rocworks.at\/wordpress\/?p=456"},"modified":"2014-06-20T08:21:55","modified_gmt":"2014-06-20T06:21:55","slug":"oracle-12c-unified-audit-trail-fills-up-sysaux-tablespace-schema-audsys","status":"publish","type":"post","link":"https:\/\/www.rocworks.at\/wordpress\/?p=456","title":{"rendered":"Oracle 12c unified audit trail fills up SYSAUX tablespace (schema AUDSYS)"},"content":{"rendered":"<p><code><br \/>\n-- clean audit trail for the current container<br \/>\nBEGIN<br \/>\n  DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(<br \/>\n   AUDIT_TRAIL_TYPE           =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,<br \/>\n   USE_LAST_ARCH_TIMESTAMP    =>  FALSE,<br \/>\n   CONTAINER                  =>  DBMS_AUDIT_MGMT.CONTAINER_CURRENT );<br \/>\nEND;<\/p>\n<p>-- drop purge job<br \/>\nBEGIN<br \/>\n DBMS_AUDIT_MGMT.DROP_PURGE_JOB(<br \/>\n  AUDIT_TRAIL_PURGE_NAME  => 'Audit_Trail_PJ');<br \/>\nEND;<br \/>\n\/<\/p>\n<p>-- create purge job for current container<br \/>\nBEGIN<br \/>\n  DBMS_AUDIT_MGMT.CREATE_PURGE_JOB (<br \/>\n   AUDIT_TRAIL_TYPE            => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,<br \/>\n   AUDIT_TRAIL_PURGE_INTERVAL  => 12,<br \/>\n   AUDIT_TRAIL_PURGE_NAME      => 'Audit_Trail_PJ',<br \/>\n   USE_LAST_ARCH_TIMESTAMP     => FALSE,<br \/>\n   CONTAINER                   => DBMS_AUDIT_MGMT.CONTAINER_CURRENT);<br \/>\nEND;<br \/>\n\/<br \/>\n\/<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; clean audit trail for the current container BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, USE_LAST_ARCH_TIMESTAMP => FALSE, CONTAINER => DBMS_AUDIT_MGMT.CONTAINER_CURRENT ); END; &#8212; drop purge job BEGIN DBMS_AUDIT_MGMT.DROP_PURGE_JOB( AUDIT_TRAIL_PURGE_NAME => &#8216;Audit_Trail_PJ&#8217;); END; \/ &#8212; create purge job for current container BEGIN &hellip; <a href=\"https:\/\/www.rocworks.at\/wordpress\/?p=456\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=456"}],"version-history":[{"count":1,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":457,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/456\/revisions\/457"}],"wp:attachment":[{"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rocworks.at\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}