SQL> SELECT AUD_APPLICATION_LOG.CREATED, AUD_APPLICATION_LOG.CREATED_BY, FN_LOCALIZE(AUD_APPLICATION_LOG.EVENT_ID,'en',AUD_APPLICATION_LOG.DATA,AUD_APPLICATION_LOG.RELOBJ_ID,AUD_APPLICATION_LOG.RELOBJ_TYPE,AUD_APPLICATION_LOG.RELOBJ_LABEL) AS DATA, AUD_APPLICATION_LOG.EVENT_ID, AUD_APPLICATION_LOG.ID, AUD_APPLICATION_LOG.RELOBJ_ID, AUD_APPLICATION_LOG.RELOBJ_LABEL, AUD_APPLICATION_LOG.RELOBJ_TYPE, SEC_OPERATOR.NAME, AUD_EVENT_DESCRIPTOR.CATEGORY, AUD_EVENT_DESCRIPTOR.SEVERITY FROM AUD_APPLICATION_LOG, AUD_EVENT_DESCRIPTOR, SEC_OPERATOR WHERE ((AUD_APPLICATION_LOG.CREATED >= TO_DATE('2014-02-14 00:00:00','YYYY-MM-DD HH24:MI:SS') AND AUD_APPLICATION_LOG.CREATED <= TO_DATE('2014-02-15 00:00:00','YYYY-MM-DD HH24:MI:SS') AND AUD_APPLICATION_LOG.CREATED IS NOT NULL)) AND AUD_APPLICATION_LOG.CREATED_BY = SEC_OPERATOR.ID AND AUD_APPLICATION_LOG.EVENT_ID = AUD_EVENT_DESCRIPTOR.ID ORDER BY ID DESC;

1235508 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 53021094

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

| Id  | Operation                      | Name                  | Rows  | Bytes |
TempSpc| Cost (%CPU)| Time     |

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

|   0 | SELECT STATEMENT               |                       |  6895 |   794K|
       |   387   (1)| 00:00:05 |

|   1 |  SORT ORDER BY                 |                       |  6895 |   794K|
   888K|   387   (1)| 00:00:05 |

|*  2 |   HASH JOIN                    |                       |  6895 |   794K|
       |   201   (1)| 00:00:03 |

|   3 |    TABLE ACCESS FULL           | AUD_EVENT_DESCRIPTOR  |    98 |  2058 |
       |     4   (0)| 00:00:01 |

|*  4 |    HASH JOIN                   |                       |  6895 |   653K|
       |   197   (1)| 00:00:03 |

|   5 |     TABLE ACCESS FULL          | SEC_OPERATOR          |    77 |  2233 |
       |     4   (0)| 00:00:01 |

|   6 |     TABLE ACCESS BY INDEX ROWID| AUD_APPLICATION_LOG   |  6895 |   457K|
       |   192   (0)| 00:00:03 |

|*  7 |      INDEX RANGE SCAN          | IX_AUD_APPLOG_CREATED |  6895 |       |
       |    24   (0)| 00:00:01 |

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


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

   2 - access("AUD_APPLICATION_LOG"."EVENT_ID"="AUD_EVENT_DESCRIPTOR"."ID")
   4 - access("AUD_APPLICATION_LOG"."CREATED_BY"="SEC_OPERATOR"."ID")
   7 - access("AUD_APPLICATION_LOG"."CREATED">=TIMESTAMP' 2014-02-14 00:00:00' A
ND

              "AUD_APPLICATION_LOG"."CREATED"<=TIMESTAMP' 2014-02-15 00:00:00')


Statistics
----------------------------------------------------------
    1235727  recursive calls
          6  db block gets
    8664966  consistent gets
      27579  physical reads
          0  redo size
  128342411  bytes sent via SQL*Net to client
     906561  bytes received via SQL*Net from client
      82369  SQL*Net roundtrips to/from client
          0  sorts (memory)
          1  sorts (disk)
    1235508  rows processed