如何监控oracle会话状态,oracle性能监控sql-监控当前会话、执行的sql及io等信息

Oracle sql

--MingJie Tian

sql plsql developer

sga

select * from v$sgainfo;

io io

select v$sess_io.*,(block_gets+consistent_gets) reads,

((block_gets+consistent_gets-physical_reads)/(block_gets+consistent_gets)) ratio from v$sess_io

where (block_gets+consistent_gets)>=1000

order by (block_gets+consistent_gets) desc;

sql

select last_load_time,

disk_reads,

sorts,

fetches,

buffer_gets,

optimizer_cost,

cpu_time,

sql_fulltext,

sql_text

from v$sql

where to_char(last_load_time)> '2011-05-10/14:00:00' # sql

order by last_load_time desc;

io

select a.sid,

block_gets,

consistent_gets,

physical_reads,

block_changes,

consistent_changes,

b.serial#,

http://www.doczj.com/doc/1a2e3b33b90d6c85ec3ac647.htmlername,

http://www.doczj.com/doc/1a2e3b33b90d6c85ec3ac647.htmlmand,

b.server,

b.machine,

b.terminal,

b.program