select * from sal_inv_fa_test where c_type='AC10CRL4D1'

 
 General 
 
 
 
Module  SQL*Plus 
Action   
Parsing Schema  SALADMIN 
PL/SQL Source (Line Number)  Not Applicable 
 
 
  
 Activity By Waits 
 
 
 
    User I/O Waits(90%)   
   CPU(10%)   
 
 
 
 
 
 
  
 Activity By Time 
 
 
 
Elapsed Time (sec)  33.41 
CPU Time (sec)  3.55 
Wait Time (sec)  29.86 
 
 
 
 
 Elapsed Time Breakdown 
 
 
 
SQL Time (sec)  33.41 
PL/SQL Time (sec)  0.00 
Java Time (sec)  0.00 
 
 
 
 
 
 Shared Cursors Statistics 
 
 
 
Total Parses  1 
Loads  1 
Child Cursors  1 
Child Cursors With Loaded Plans  1 
Invalidations  0 
Largest Cursor Size (KB)  28.47 
All Cursor Size (KB)  28.47 
First Load Time  Sep 23, 2010 11:23:11 AM 
Last Load Time  Sep 23, 2010 11:23:11 AM 
 
 
  
 Execution Statistics 
 
 
 

 Total Per Execution Per Row 
Executions 1 1 0.33 
CPU Time (sec) 3.55 3.55 1.18 
Buffer Gets 109167 109167.00 36389.00 
Disk Reads 108448 108448.00 36149.33 
Direct Writes 0 0.00 0.00 
Rows 3 3.00 1 
Fetches 2 2.00 0.67 
 
 
 
 
  
 Other Statistics 
 
 
 
Executions that Fetched all Rows (%)  100.00 
Average Persistent Mem (KB)  9.75 
Average Runtime Mem (KB)  5.65 
Serializable Aborts  0 
Remote  No 
Obsolete  No 
Child Latch Number  5