PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 294068423

----------------------------------------------------------------------------------------------------
| Id  | Operation                        | Name                      | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------
|   0 | UPDATE STATEMENT                 |                           |  7572 |   443K|  2950   (2)| 00:00:36 |
|   1 |  UPDATE                          | NOTIFICATION_MSG          |       |       |            |          |
|*  2 |   COUNT STOPKEY                  |                           |       |       |            |          |
|   3 |    CONCATENATION                 |                           |       |       |            |          |
|*  4 |     FILTER                       |                           |       |       |            |          |
|   5 |      NESTED LOOPS SEMI           |                           |     2 |   120 |    10   (0)| 00:00:01 |
|*  6 |       TABLE ACCESS BY INDEX ROWID| NOTIFICATION_MSG          |     2 |   108 |     6   (0)| 00:00:0
|*  7 |        INDEX RANGE SCAN          | IX2_NOTIFICATION_MSG      |    63 |       |     3   (0)| 00:00:01 |
|*  8 |       INDEX RANGE SCAN           | IX1_NOTIFICATION_MSG_PARM |  1144K|  6704K|     2   (0)| 00:00:01 |
|*  9 |     FILTER                       |                           |       |       |            |          |
|* 10 |      HASH JOIN SEMI              |                           |  7570 |   443K|  2940   (2)| 00:00:36 |
|* 11 |       TABLE ACCESS BY INDEX ROWID| NOTIFICATION_MSG          |  7570 |   399K|  2254   (1)| 00:00:2
|* 12 |        INDEX RANGE SCAN          | IX2_NOTIFICATION_MSG      | 60623 |       |   136   (2)| 00:00:02 
|  13 |       INDEX FAST FULL SCAN       | IX1_NOTIFICATION_MSG_PARM |  1144K|  6704K|   672   (3)| 00:00:09
----------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter(ROWNUM<=TO_NUMBER(:4))
   4 - filter(ROWNUM<=TO_NUMBER(:4))
   6 - filter("MSG_SND_TRY_CNT"<TO_NUMBER(:5) AND "CREATE_DATE"<=SYSDATE@!-INTERVAL'+00 00:05:00'
              DAY(2) TO SECOND(0))
   7 - access("NOTF_MSG_STAT_CODE"=:2 AND "BATCH_PRCS_ID"=:3)
   8 - access("PARMS"."NOTF_MSG_ID"="MSG"."NOTF_MSG_ID")
   9 - filter(ROWNUM<=TO_NUMBER(:4))
  10 - access("PARMS"."NOTF_MSG_ID"="MSG"."NOTF_MSG_ID")
  11 - filter("MSG_SND_TRY_CNT"<TO_NUMBER(:5) AND "CREATE_DATE"<=SYSDATE@!-INTERVAL'+00 00:05:00'
              DAY(2) TO SECOND(0))
  12 - access("NOTF_MSG_STAT_CODE"=:2 AND "BATCH_PRCS_ID" IS NULL)
       filter(LNNVL("BATCH_PRCS_ID"=:3))

Note
-----
   - 'PLAN_TABLE' is old version

40 rows selected.

Elapsed: 00:00:00.95

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=29 Card=8168 Bytes
          =16336)

   1    0   COLLECTION ITERATOR (PICKLER FETCH) OF 'DISPLAY' (PROCEDUR
          E)





Statistics
----------------------------------------------------------
       1488  recursive calls
         22  db block gets
       2370  consistent gets
        156  physical reads
          0  redo size
       3483  bytes sent via SQL*Net to client
        457  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
         20  sorts (memory)
          0  sorts (disk)
         40  rows processed