io
DATA_FILE TABLESPACE PHYRDS PHYBLKRD RATI PHYWRTS ------------------------------ ---------- ---------- ---------- ---- ---------- /oracle1/oradata/stage/data/st SYSTEM 5075 7098 1 656 /oracle1/oradata/stage/data/st RBS_A 78 78 1 59797 /oracle1/oradata/stage/data/st RBS_B 72 72 1 53444 /oracle1/oradata/stage/data/st TEMP 104968 175712 1 30366 /oracle1/oradata/stage/data/st TOOLS 462 462 1 57 /oracle1/oradata/stage/data/st USERS 68 68 1 57 /oracle1/oradata/stage/data/st DATA 43076 104666 2 40351 /oracle1/oradata/stage/indx/st INDX 11748 13364 1 47167 /oracle1/oradata/stage/data/st DATA_PART1 61 61 1 57 /oracle1/oradata/stage/indx/st INDX_PART1 61 61 1 57 /oracle1/oradata/stage/data/st DATA_PART2 61 61 1 57 /oracle1/oradata/stage/indx/st INDX_PART2 61 61 1 57 /oracle1/oradata/stage/data/st IMPDATA1 17611 139764 7 4688 /oracle1/oradata/stage/data/st IMPDATA2 208 208 1 139 /oracle1/oradata/stage/indx/st IMPINDX1 82 82 1 12370 /oracle1/oradata/stage/indx/st IMPINDX2 246 246 1 57 16 rows selected. SQL> SQL> SQL> 2 from v$sysstat 3 where name like 'table scans%'; NAME VALUE ---------------------------------------------------------------- ---------- table scans (short tables) 1182087 table scans (long tables) 52 table scans (rowid ranges) 0 table scans (cache partitions) 0 table scans (direct read) 0