0 Replies Latest reply on Oct 4, 2011 1:51 PM by 669592

    Purge on ECX_OXTA_LOGMSG

    669592
      Hello,

      I would like to know if there is a procedure to purge the lines from the ECX_OXTA_LOGMSG table. I Search on metalink but i dind't see anything leading to this way.

      The customer has a very old system .
      SQL> select release_name from apps.fnd_product_groups;

      RELEASE_NAME
      --------------------------------------------------
      11.5.3

      SQL*Plus: Release 8.1.7.0.0 - Production on Tue Oct 4 10:49:25 2011

      SunOS csna0005 5.9 Generic_122300-35 sun4u sparc SUNW,Sun-Fire-480R


      Physical Reads Executions Reads per Exec % Total Hash Value

      --------------- ------------ -------------- ------- ------------

      315,323,295 9,856 31,993.0 41.5 1057002001

      SELECT SENDER_MESSAGE_ID, DIRECTION, STATUS, BEGIN_DATE, R

      EQUEST_TYPE, CONTENT_LENGTH, TRANSACTION_TYPE, USERNAME, IP_

      ADDRESS, PROTOCOL_TYPE, PROTOCOL_ADDRESS, RESULT_CODE, RESUL

      T_TEXT, RECEIPT_MESSAGE_ID, COMPLETED_DATE, EXCEPTION_TEXT F

      ROM ECX_OXTA_LOGMSG WHERE DIRECTION = :1 AND NOT RESULT_CODE =

      :2 AND COMPLETED_DATE = ( SELECT MAX(COMPLETED_DATE) FROM ECX_

      OXTA_LOGMSG WHERE STATUS = 'COMPLETED' AND REQUEST_TYPE = 'SEN

      D' AND DIRECTION = :3 AND NOT RESULT_CODE = :4 )





      158,437,634 9,858 16,072.0 20.8 1863727201

      SELECT SENDER_MESSAGE_ID, DIRECTION, STATUS, BEGIN_DATE, R

      EQUEST_TYPE, CONTENT_LENGTH, TRANSACTION_TYPE, USERNAME, IP_

      ADDRESS, PROTOCOL_TYPE, PROTOCOL_ADDRESS, RESULT_CODE, RESUL

      T_TEXT, RECEIPT_MESSAGE_ID, COMPLETED_DATE, EXCEPTION_TEXT F

      ROM ECX_OXTA_LOGMSG WHERE DIRECTION = :1 AND RESULT_CODE = :2

      AND COMPLETED_DATE = ( SELECT MAX(COMPLETED_DATE) FROM ECX_OXTA

      LOGMSG  WHERE STATUS = 'COMPLETED'  AND REQUESTTYPE = 'SEND'

      AND DIRECTION = :3 AND RESULT_CODE = :4 )