set pagesize 999
set linesize 132
col username format a10
col os_user format a10
col pid format 9999
col sid format 99999
column serial# format 9999999
col PHYSICAL_READS format 9999999
col BLOCK_GETS format 999999999
col CONSISTENT_GETS format 9999999999
col BLOCK_CHANGES format 99999999
col CONSISTENT_CHANGES format 9999999
select username,
OSUSER os_user,
PROCESS pid,
ses.SID sid,
SERIAL#,
PHYSICAL_READS,
BLOCK_GETS,
CONSISTENT_GETS,
BLOCK_CHANGES,
CONSISTENT_CHANGES
from v$session ses,
v$sess_io sio
where ses.SID = sio.SID
order by PHYSICAL_READS, ses.USERNAME
/
set linesize 132
col username format a10
col os_user format a10
col pid format 9999
col sid format 99999
column serial# format 9999999
col PHYSICAL_READS format 9999999
col BLOCK_GETS format 999999999
col CONSISTENT_GETS format 9999999999
col BLOCK_CHANGES format 99999999
col CONSISTENT_CHANGES format 9999999
select username,
OSUSER os_user,
PROCESS pid,
ses.SID sid,
SERIAL#,
PHYSICAL_READS,
BLOCK_GETS,
CONSISTENT_GETS,
BLOCK_CHANGES,
CONSISTENT_CHANGES
from v$session ses,
v$sess_io sio
where ses.SID = sio.SID
order by PHYSICAL_READS, ses.USERNAME
/
Comments