2 Replies Latest reply: Nov 29, 2012 6:55 AM by 976987 RSS

    opidcl aborting process unknown ospid (21731) as a result of ORA-604

    976987
      LINUX RED HAT 5.4
      ORACLE 11.2.0.3

      ALTER日志如下:
      opidcl aborting process unknown ospid (21731) as a result of ORA-604
      opidcl aborting process unknown ospid (24347) as a result of ORA-604

      Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of ASHSIZE to a sufficiently large value. Currently, ASH size is 67108864 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:
      select total_size,awr_flush_emergency_count from v$ash_info;

      最终导致数据库hang住,应用中断
      2分钟左右后,应用可以正常使用,导致应用非常慢!