{"id":35,"date":"2004-10-21T09:27:28","date_gmt":"2004-10-21T16:27:28","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/?p=35"},"modified":"2004-10-21T09:27:28","modified_gmt":"2004-10-21T16:27:28","slug":"owb-runtime-how-to-purge-audit-data-easily","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2004\/10\/21\/owb-runtime-how-to-purge-audit-data-easily\/","title":{"rendered":"OWB Runtime : How to purge audit data easily"},"content":{"rendered":"<p>The OWB runtime generates runtime audit data for every process, mapping, and file loading that it invokes.  If you have intricate flows and load your warehouse\/mart several times a day (every 5 minutes perhaps?) you&#8217;ll see these pile up quickly.  The easiest user method for purging this audit data is through the OWB Runtime Browser that allows you to select (checkbox).<\/p>\n<div align=\"center\"><img decoding=\"async\" loading=\"lazy\" src=\"\/entry_images\/execution_checkbox.JPG\" width=\"299\" height=\"189\" alt=\"\" border=\"0\">\n<\/div>\n<p>Sometimes you don&#8217;t want to manually do this, but rather have a way to do this programatically.  Perhaps because you want to keep a clean house (always purge greater than 30 days old).  Perhaps you generate a lot of audit data in a development environment that&#8217;s a hassle to delete from OWB RT Browser.  Perhaps you rarely visit the OWB RT and don&#8217;t want to fuss with keeping it up.<\/p>\n<p>Whatever your reason, please feel free to use the following little script to systematically purge old audit data.  It must be run as your OWB Runtime Owner.  I&#8217;ve not run this by Oracle, or seen them document this API so use it at your own risk.  It works, though.<\/p>\n<pre>\nbegin<br \/>\n  for purge_ids in (select distinct top_level_execution_audit_id id<br \/>\n            from ALL_RT_AUDIT_EXECUTIONS<br \/>\n            where updated_on<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The OWB runtime generates runtime audit data for every process, mapping, and file loading that it invokes. If you have intricate flows and load your warehouse\/mart several times a day (every 5 minutes perhaps?) you&#8217;ll see these pile up quickly. The easiest user method for purging this audit data is through the OWB Runtime Browser [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/35"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=35"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}