SQL> SET LINESIZE 130
SQL>  SET PAGESIZE 0
SQL>  SELECT * FROM table(DBMS_XPLAN.DISPLAY);
Plan hash value: 3712814491                                                                                                       
                                                                                                                                  
----------------------------------------------------------------------------------------------------------------------------------
-------                                                                                                                           
                                                                                                                                  
| Id  | Operation                                 | Name                        | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| 
Pstop |                                                                                                                           
                                                                                                                                  
----------------------------------------------------------------------------------------------------------------------------------
-------                                                                                                                           
                                                                                                                                  
|   0 | SELECT STATEMENT                          |                             | 50857 |  7151K| 93382   (1)| 00:18:41 |       | 
      |                                                                                                                           
                                                                                                                                  
|*  1 |  FILTER                                   |                             |       |       |            |          |       | 
      |                                                                                                                           
                                                                                                                                  
|*  2 |   HASH JOIN                               |                             | 50857 |  7151K| 93382   (1)| 00:18:41 |       | 
      |                                                                                                                           
                                                                                                                                  
|   3 |    PARTITION HASH ALL                     |                             |  2312 | 23120 |    25   (0)| 00:00:01 |     1 | 
    5 |                                                                                                                           
                                                                                                                                  
|*  4 |     TABLE ACCESS FULL                     | CAT_ITEM_PARAMETER          |  2312 | 23120 |    25   (0)| 00:00:01 |     1 | 
    5 |                                                                                                                           
                                                                                                                                  
|*  5 |    HASH JOIN                              |                             | 94938 |    12M| 93356   (1)| 00:18:41 |       | 
      |                                                                                                                           
                                                                                                                                  
|*  6 |     TABLE ACCESS FULL                     | ITEM_POOL_VERSION           |  9036 |   132K|    30   (0)| 00:00:01 |       | 
      |                                                                                                                           
                                                                                                                                  
|*  7 |     TABLE ACCESS BY GLOBAL INDEX ROWID    | CAT_ITEM_USER_RESPONSE      |     9 |   279 |    18   (0)| 00:00:01 | ROWID | 
ROWID |                                                                                                                           
                                                                                                                                  
|   8 |      NESTED LOOPS                         |                             | 45349 |  5270K| 93325   (1)| 00:18:40 |       | 
      |                                                                                                                           
                                                                                                                                  
|*  9 |       HASH JOIN                           |                             |  4923 |   423K| 11377   (1)| 00:02:17 |       | 
      |                                                                                                                           
                                                                                                                                  
|* 10 |        INDEX FAST FULL SCAN               | INSTI_ID_NAME_COUN_DISP_IDX |  8165 |   111K|    18   (0)| 00:00:01 |       | 
      |                                                                                                                           
                                                                                                                                  
|* 11 |        HASH JOIN                          |                             |  4923 |   355K| 11359   (1)| 00:02:17 |       | 
      |                                                                                                                           
                                                                                                                                  
|* 12 |         TABLE ACCESS BY GLOBAL INDEX ROWID| TEST_SESSION_DETAIL         |  4107 |   148K|  6804   (1)| 00:01:22 | ROWID | 
ROWID |                                                                                                                           
                                                                                                                                  
|  13 |          NESTED LOOPS                     |                             |  4923 |   278K|  6806   (1)| 00:01:22 |       | 
      |                                                                                                                           
                                                                                                                                  
|* 14 |           INDEX RANGE SCAN                | TEST_DETAIL_AK_1            |     1 |    21 |     2   (0)| 00:00:01 |       | 
      |                                                                                                                           
                                                                                                                                  
|* 15 |           INDEX RANGE SCAN                | TEST_SESSION_DETAIL_FK2_I   | 39737 |       |   102   (0)| 00:00:02 |       | 
      |                                                                                                                           
                                                                                                                                  
|  16 |         PARTITION HASH ALL                |                             |  1672K|    25M|  4546   (1)| 00:00:55 |     1 | 
    5 |                                                                                                                           
                                                                                                                                  
|  17 |          TABLE ACCESS FULL                | TEST_SESSION                |  1672K|    25M|  4546   (1)| 00:00:55 |     1 | 
    5 |                                                                                                                           
                                                                                                                                  
|* 18 |       INDEX RANGE SCAN                    | CAT_ITEM_USER_RESP_IDX1     |    18 |       |     3   (0)| 00:00:01 |       | 
      |                                                                                                                           
                                                                                                                                  
----------------------------------------------------------------------------------------------------------------------------------
-------                                                                                                                           
                                                                                                                                  
                                                                                                                                  
Predicate Information (identified by operation id):                                                                               
---------------------------------------------------                                                                               
                                                                                                                                  
   1 - filter(TO_DATE('01-11-09','dd-mm-yy')<=TO_DATE('30-11-09','dd-mm-yy'))                                                     
   2 - access("P"."ITEM_ID"="I"."ITEM_ID")                                                                                        
   4 - filter("P"."PRETEST"=0)                                                                                                    
   5 - access("I"."ITEM_ID"="C"."ITEM_ID")                                                                                        
   6 - filter("I"."POOL_AVAILABILITY"='Y')                                                                                        
   7 - filter(TO_NUMBER("C"."RESTART_FLAG")=0)                                                                                    
   9 - access("S"."INSTITUTION_ID"="E"."INSTITUTION_ID")                                                                          
  10 - filter(SUBSTR("E"."INSTITUTION_ID_DISPLAY",8,3)<>'000')                                                                    
  11 - access("S"."TEST_SESSION_ID"="T"."TEST_SESSION_ID")                                                                        
  12 - filter(TRUNC(INTERNAL_FUNCTION("T"."TEST_END_DATE"))>=TO_DATE('01-11-09','dd-mm-yy') AND "T"."TEST_SESSION_STATUS_ID"=3    
              AND TRUNC(INTERNAL_FUNCTION("T"."TEST_END_DATE"))<=TO_DATE('30-11-09','dd-mm-yy'))                                  
  14 - access("D"."TEST_NAME"='Reading Comprehension')                                                                            
  15 - access("T"."TEST_DETAIL_ID"="D"."TEST_DETAIL_ID")                                                                          
  18 - access("C"."TEST_SESSION_DETAIL_ID"="T"."TEST_SESSION_DETAIL_ID")                                                          

43 rows selected.

SQL> SPOOL OFF;