How to see the i/o for each tempfile in temporary tablespace Posted by Unknown on October 06, 2016 Get link Facebook X Pinterest Email Other Apps SET PAGESIZE 1000 SELECT SUBSTR(t.name,1,50) AS file_name, f.phyblkrd AS blocks_read, f.phyblkwrt AS blocks_written, f.phyblkrd + f.phyblkwrt AS total_io FROM v$tempstat f, v$tempfile t WHERE t.file# = f.file# ORDER BY f.phyblkrd + f.phyblkwrt DESC; Comments
Comments