{"id":1425,"date":"2008-08-05T12:00:00","date_gmt":"2008-08-05T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1425"},"modified":"2008-08-05T12:00:00","modified_gmt":"2008-08-05T12:00:00","slug":"hanging-audit-vault-warehouse-refresh-job","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2008\/08\/05\/hanging-audit-vault-warehouse-refresh-job\/","title":{"rendered":"Hanging Audit Vault Warehouse Refresh Job"},"content":{"rendered":"<p>I&#8217;ve been working with <a href=\"http:\/\/www.oracle.com\/technology\/products\/audit-vault\/index.html\">Audit Vault 10.2.3<\/a> on AIX recently and ran into a problem that someone else might one day. I decided to capture the output as best I can and blog about it later. (As I don&#8217;t have the same system available any more, the formatting might leave a bit to be desired and there are one or two little steps missing that I would liked to have shown but I don&#8217;t think they&#8217;re crucial.)<\/p>\n<p>It was just a Pre-Production system that we could play around with but I noticed that there were no recent audit trail entries when I tried some tests. On closer inspection, the most recent audit record was a couple of days old, so it looked like the job which inserts new audit records into the Audit Vault Data Warehouse wasn&#8217;t running properly. The first step was to connect to that database instance and check the status of the job.<\/p>\n<pre>SQL&gt; select owner, job_name, elapsed_time from all_scheduler_running_jobs; \n\nOWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 JOB_NAME \n------------------------------ ------------------------------ \nELAPSED_TIME \n--------------------------------------------------------------------------- \nAVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 REFRESH_WAREHOUSE_DATA \n+002 21:06:37.19<\/pre>\n<p>OK, so the Warehouse Refresh job has been running for a few days (2 days, 21 hours and 6 minutes). When I looked at the session for that job, it was waiting on &#8220;enq: PS &#8211; contention&#8221; which is (trumpet salute) a parallel execution wait event. <\/p>\n<pre>\u00a0 1\u00a0 select sid, username, last_call_et, event, wait_time, seconds_in_wait, state, \n            blocking_session, blocking_session_status \n\u00a0 2\u00a0 from v$session \n\u00a0 3* where sid=201 \nSQL&gt; \/ \n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LAST_CALL_ET \n---------- ------------------------------ ------------ \nEVENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WAIT_TIME \n---------------------------------------------------------------- ---------- \nSECONDS_IN_WAIT STATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BLOCKING_SESSION BLOCKING_SE \n--------------- ------------------- ---------------- ----------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 201 AVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 249575 \nenq: PS - contention\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 48361 WAITING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169 VALID<\/pre>\n<p>It&#8217;s a bit of a red herring because it&#8217;s really waiting on the PX slave, so the real event should be in that session 169.<\/p>\n<pre>SQL&gt; c\/201\/169 \n\u00a0 3* where sid=169 \nSQL&gt; \/ \n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LAST_CALL_ET \n---------- ------------------------------ ------------ \nEVENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WAIT_TIME \n---------------------------------------------------------------- ---------- \nSECONDS_IN_WAIT STATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BLOCKING_SESSION BLOCKING_SE \n--------------- ------------------- ---------------- ----------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169 AVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 249250 \ncursor: pin X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 WAITING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNKNOWN<\/pre>\n<p>So, looking at that made me Google around and come up with <a href=\"http:\/\/www.orafaq.com\/usenet\/comp.databases.oracle.server\/2007\/06\/13\/0387.htm%20\">this<\/a>. Which implies that I should look at bug number 5908030 which is stated as a duplicate of 5476091. Both RDBMS bugs and both will be fixed in (gulp) 11.2.<\/p>\n<p>The next job was to kill the currently running refresh job and restart it, particularly as this was just Pre-Prod and the lack of audit records in the Warehouse was holding up testing. I tried various approaches to stopping the job, running from the highest level more elegant approaches, down to brute force. <\/p>\n<pre>SQL&gt; exec dbms_scheduler.stop_job('AVSYS.REFRESH_WAREHOUSE_DATA'); \nBEGIN dbms_scheduler.stop_job('AVSYS.REFRESH_WAREHOUSE_DATA'); END; \n\n* \nERROR at line 1: \nORA-27365: job has been notified to stop, but failed to do so immediately \nORA-06512: at \"SYS.DBMS_ISCHED\", line 164 \nORA-06512: at \"SYS.DBMS_SCHEDULER\", line 483 \nORA-06512: at line 1 <\/pre>\n<p>Tried that a few times and decided it was probably well and truly stuck, particularly when the bugs were referring to systemstate dumps, so I tried killing the stuck slave, first <\/p>\n<pre>\u00a01\u00a0 select sid, username, last_call_et, event, wait_time, seconds_in_wait, state, \n           blocking_session, blocking_session_status \n 2\u00a0 from v$session \n 3* where sid=201 \nSQL&gt; \/ \n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LAST_CALL_ET \n---------- ------------------------------ ------------ \nEVENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WAIT_TIME \n---------------------------------------------------------------- ---------- \nSECONDS_IN_WAIT STATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BLOCKING_SESSION BLOCKING_SE \n--------------- ------------------- ---------------- ----------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 201 AVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 251777 \nenq: PS - contention\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 50563 WAITING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169 VALID \nSQL&gt; 3 \n\u00a0 3* where sid=201 \nSQL&gt; c\/201\/169 \n\u00a0 3* where sid=169 \nSQL&gt; \/ \n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LAST_CALL_ET \n---------- ------------------------------ ------------ \nEVENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WAIT_TIME \n---------------------------------------------------------------- ---------- \nSECONDS_IN_WAIT STATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BLOCKING_SESSION BLOCKING_SE \n--------------- ------------------- ---------------- ----------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169 AVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 251446 \ncursor: pin X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 WAITING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNKNOWN \n\nSQL&gt; select sid, serial# from v$session where sid=169; \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID\u00a0\u00a0\u00a0 SERIAL# \n---------- ---------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1585 \n\nSQL&gt; alter system kill session '169,1585'; \nalter system kill session '169,1585' \n* \nERROR at line 1: \nORA-00031: session marked for kill <\/pre>\n<p>I waited and tried a few more times, but that slave really didn&#8217;t want to die &#8230;<\/p>\n<pre>SQL&gt; l \n\u00a0 1\u00a0 select sid, username, last_call_et, event, wait_time, seconds_in_wait, state, \n            blocking_session, blocking_session_status \n\u00a0 2\u00a0 from v$session \n\u00a0 3* where sid=169 \nSQL&gt; \/ \n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LAST_CALL_ET \n---------- ------------------------------ ------------ \nEVENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WAIT_TIME \n---------------------------------------------------------------- ---------- \nSECONDS_IN_WAIT STATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 BLOCKING_SESSION BLOCKING_SE \n--------------- ------------------- ---------------- ----------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169 AVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 251725 \ncursor: pin X\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 WAITING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNKNOWN <\/pre>\n<p>So I tried try killing the process<\/p>\n<pre>SQL&gt; select sid, serial#, paddr, osuser, process, status \n\u00a0 2\u00a0 from v$session where sid=169; \n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SID\u00a0\u00a0\u00a0 SERIAL# PADDR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OSUSER \n---------- ---------- ---------------- ------------------------------ \nPROCESS\u00a0\u00a0\u00a0\u00a0\u00a0 STATUS \n------------ -------- \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 169\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1585 070000005A383348 oracle \n962750\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 KILLED \n\nSQL&gt; !ps -ef|grep 962750 \n\u00a0 oracle\u00a0 962750\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0 1\u00a0\u00a0 Jul 13\u00a0\u00a0\u00a0\u00a0\u00a0 - 11:49 ora_p006_AV01TEST \n\u00a0 oracle 1519634 1757348\u00a0\u00a0 2 12:11:27\u00a0 pts\/1\u00a0 0:00 grep 962750 \nSQL&gt; !kill -9 962750 \nSQL&gt; !ps -ef|grep 962750 \n\u00a0 oracle 1519638 1757348\u00a0\u00a0 1 12:11:38\u00a0 pts\/1\u00a0 0:00 grep 962750 <\/pre>\n<p>Now it&#8217;s gone, see if parent session for refresh job is still there <\/p>\n<pre>\u00a0 1\u00a0 select sid, username, last_call_et, event, wait_time, seconds_in_wait, state, \n            blocking_session, blocking_session_status \n\u00a0 2\u00a0 from v$session \n\u00a0 3* where sid=201 \nSQL&gt; \/ \n\nno rows selected <\/pre>\n<p>No, so the job should be gone too <\/p>\n<pre>SQL&gt; select * from all_scheduler_running_jobs; \n\nOWNER\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 JOB_NAME \n------------------------------ ------------------------------ \nJOB_SUBNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SESSION_ID SLAVE_PROCESS_ID SLAVE_OS_PRO \n------------------------------ ---------- ---------------- ------------ \nRUNNING_INSTANCE RESOURCE_CONSUMER_GROUP \n---------------- -------------------------------- \nELAPSED_TIME \n--------------------------------------------------------------------------- \nCPU_USED \n--------------------------------------------------------------------------- \nAVSYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 REFRESH_WAREHOUSE_DATA \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 122\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19 692392 \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 \n+000 00:01:25.48 \n+000 00:00:18.38 <\/pre>\n<p>Well, it had restarted and been running for a minute or so. The audit trail entries started to appear in the warehouse, anyway. As I won&#8217;t be working with this again for a while, I&#8217;m counting on colleagues to keep me posted about whether this keeps happening!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve been working with Audit Vault 10.2.3 on AIX recently and ran into a problem that someone else might one day. I decided to capture the output as best I can and blog about it later. (As I don&#8217;t have the same system available any more, the formatting might leave a bit to be desired&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2008\/08\/05\/hanging-audit-vault-warehouse-refresh-job\/\">Continue reading <span class=\"screen-reader-text\">Hanging Audit Vault Warehouse Refresh Job<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1425","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1466,"url":"http:\/\/orcldoug.com\/blog\/2009\/01\/27\/adding-a-new-oracle-host-to-audit-vault\/","url_meta":{"origin":1425,"position":0},"title":"Adding a new Oracle host to Audit Vault","date":"January 27, 2009","format":false,"excerpt":"This one's been outstanding for a while. After my presentation on Audit Vault at UKOUG, the AV Product Manager Tammy Bednar sent me a couple of corrections to the configuration section. Rather than just amend the slides, I was keen to wait until I had another chance to configure a\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1408,"url":"http:\/\/orcldoug.com\/blog\/2008\/05\/19\/conference-activities\/","url_meta":{"origin":1425,"position":1},"title":"Conference Activities","date":"May 19, 2008","format":false,"excerpt":"I should get to bed soon because I have to be up at 4am for my flight to Stockholm (via Copenhagen). Tomorrow (and on Wednesday) I'll be presenting at the Swedish and Finnish Oracle User Groups joint 20th Anniversary event on the good ship (I hope) m\/s Silja Serenade. The\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1407,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/30\/oug-scotland-dba-sig\/","url_meta":{"origin":1425,"position":2},"title":"OUG Scotland DBA SIG","date":"April 30, 2008","format":false,"excerpt":"An enjoyable day, but it flew by. Having not had much sleep last night through worrying about the first time I was giving this particular presentation, I'm glad I was able to present in the second slot of the day because I knew I'd be flagging later on. The most\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1461,"url":"http:\/\/orcldoug.com\/blog\/2008\/12\/10\/ukoug-days-4-and-5\/","url_meta":{"origin":1425,"position":3},"title":"UKOUG Days 4 and 5","date":"December 10, 2008","format":false,"excerpt":"I woke up on the last full day of the conference with a couple of small things left to do on my second presentation. I was confident, though, because it was just a bit of tidying up. Mmmm, that turned out be a mistake \ud83d\ude09First, though was Graham Wood's \"Cool\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1418,"url":"http:\/\/orcldoug.com\/blog\/2008\/06\/08\/advert-future-plans\/","url_meta":{"origin":1425,"position":4},"title":"Advert &#8211; Future Plans","date":"June 8, 2008","format":false,"excerpt":"After over a year at my current site, I've decided that it's time for something new. I'm currently involved in a Grid Control and Audit Vault implementation project but I'll only be spending another 6 weeks on that. My current client have one of their best permies working on it,\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1430,"url":"http:\/\/orcldoug.com\/blog\/2008\/08\/17\/my-openworld-schedule\/","url_meta":{"origin":1425,"position":5},"title":"My Openworld Schedule","date":"August 17, 2008","format":false,"excerpt":"Knowing myself, I doubt it will end up quite like this, but I thought I'd throw together an approximation. (I must say, the schedule builder this year is a significant improvement on previous years. It doesn't have a jet-lag adjustor, but you can't have everything.)Sunday, Sep 21 10:00-11:30 Building an\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1425"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1425\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1425"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}