SQL> set autot traceonly 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_APPLIC ATION_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.CREA TED_BY = SEC_OPERATOR.ID AND AUD_APPLICATION_LOG.EVENT_ID = AUD_EVENT_DESCRIPTOR.ID; 1235508 rows selected. Execution Plan ---------------------------------------------------------- Plan hash value: 1970997936 -------------------------------------------------------------------------------- ----------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------------- ----------------------- | 0 | SELECT STATEMENT | | 6895 | 794K| 201 (1)| 00:00:03 | |* 1 | HASH JOIN | | 6895 | 794K| 201 (1)| 00:00:03 | | 2 | TABLE ACCESS FULL | AUD_EVENT_DESCRIPTOR | 98 | 2058 | 4 (0)| 00:00:01 | |* 3 | HASH JOIN | | 6895 | 653K| 197 (1)| 00:00:03 | | 4 | TABLE ACCESS FULL | SEC_OPERATOR | 77 | 2233 | 4 (0)| 00:00:01 | | 5 | TABLE ACCESS BY INDEX ROWID| AUD_APPLICATION_LOG | 6895 | 457K| 192 (0)| 00:00:03 | |* 6 | INDEX RANGE SCAN | IX_AUD_APPLOG_CREATED | 6895 | | 24 (0)| 00:00:01 | -------------------------------------------------------------------------------- ----------------------- Predicate Information (identified by operation id): --------------------------------------------------- 1 - access("AUD_APPLICATION_LOG"."EVENT_ID"="AUD_EVENT_DESCRIPTOR"."ID") 3 - access("AUD_APPLICATION_LOG"."CREATED_BY"="SEC_OPERATOR"."ID") 6 - 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 ---------------------------------------------------------- 1235513 recursive calls 0 db block gets 8827326 consistent gets 0 physical reads 0 redo size 128342424 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) 0 sorts (disk) 1235508 rows processed