set linesize 120 col osuser format a10 col username format 10 select OSUSER osuser, username, PROCESS pid, ses.SID sid, SERIAL#, PHYSICAL_READS, BLOCK_CHANGES from v$session ses, v$sess_io sio where ses.SID = sio.SID order by PHYSICAL_READS;
Script – Monitor sessions with high Physical Reads
最新推荐文章于 2024-01-20 09:34:12 发布