List Table Scans and Fetch Statistics Since Startup
--
-- List List Table Scans and Fetch Statistics Since Startup
--
 
SET PAUSE ON
SET PAUSE 'Press return to Continue'
SET LINESIZE 300
SET PAGESIZE 60
 
COL name FOR A36
COL value FOR 999,999,999,999
 
SELECT * 
FROM 
  gv$sysstat 
WHERE
  name like 'table%'
ORDER by INST_ID, NAME
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License