q_table_scan

admin

1. CLEAR COLUMNS BREAKS COMPUTES
   
2. 
   
3. COLUMN large_table_scans   FORMAT 999,999,999,999,999  HEADING 'Large Table Scans'   ENTMAP off
   
4. COLUMN small_table_scans   FORMAT 999,999,999,999,999  HEADING 'Small Table Scans'   ENTMAP off
   
5. COLUMN pct_large_scans                                 HEADING 'Pct. Large Scans'    ENTMAP off
   
6. 
   
7. SELECT a.value large_table_scans,
   
8.        b.value small_table_scans,
   
9.        ROUND(100 * a.value /
   
10.              DECODE((a.value + b.value), 0, 1, (a.value + b.value)),
    
11.              2) pct_large_scans
    
12.   FROM v$sysstat a, v$sysstat b
    
13. WHERE a.name = 'table scans (long tables)'
    
14.    AND b.name = 'table scans (short tables)'

复制代码