0 Replies Latest reply: Jun 14, 2010 3:23 PM by 779228 RSS

    Incremental results not purged from table

    779228
      Hi All,

      The rules set up on our Production database() have been causing high temp space usage alerts in the range (30-40 GB).

      When I was checking the primitive events tables, one of them (RLM$PRMEVENTS_670276) associated with a particular event contains unconsumed 82 primitive events from 5/13/2010 to 6/3/2010. The corresponding incremental result table (RLM$PRMINCRSLT_670276) has 244182320 records.

      Our production database was having issues during the past few days where the RAC Nodes got evicted by CRS 3 times in last 1 month without leaving any traces / debug info.

      So, I am presuming that this could have caused an issue with the scheduler job (EXFSYS.RLM$EVTCLEANUP) which cleans up the events and incremental results.

      Could this be causing the high temp usage issue ?

      As we are using Oracle 10.2 and dont have access to the DBMS_RLMGR.PURGE_EVENTS API, can we instead truncate the RLM$PRMEVENTS_670276 and RLM$PRMINCRSLT_670276 tables ?

      Please let me know your thoughts and possible solutions.

      Thanks,
      Ashwath