AWR/ADDM Snapshots Stopped Generating with Error 'ORA-12751: cpu time or run time policy violation' (Doc ID 2480777.1)

Last updated on JULY 22, 2024

Applies to:

Symptoms

• AWR/ADDM snapshots have stopped generating
• MMON tracefile shows following error:
  
  ORA-12751: cpu time or run time policy violation
   
•   10046 trace shows highest elpased time on insert into wrh$_sql_bind_metadata:
  insert into wrh$_sql_bind_metadata (dbid, con_dbid, snap_id, sql_id,
  name, position, dup_position, datatype, datatype_string,
  character_sid, precision, scale, max_length ) SELECT /*+ ordered
  use_nl(bnd) index(bnd sql_id) */ :dbid, :srcdbid con_dbid, :lah_snap_id,
  bnd.sql_id, name, position, dup_position, datatype, datatype_string,
  character_sid, precision, scale, max_length FROM x$kewrattrnew new,
  x$kewrsqlidtab tab, v$sql_bind_capture bnd WHERE (1 = 1) AND
  new.str1_kewrattr = tab.sqlid_kewrsie AND tab.sqlid_kewrsie =
  bnd.sql_id AND tab.childaddr_kewrsie = bnd.child_address

  call count cpu elapsed disk query current rows
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  Parse 1 0.00 0.00 0 0 0 0
  Execute 1 259.19 258.82 0 89 445 2718
  Fetch 0 0.00 0.00 0 0 0 0
  ------- ------ -------- ---------- ---------- ---------- ---------- ----------
  total 2 259.19 258.82 0 89 445 2718

    
  
  

Changes

 No changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.