« 泰山之巅 | Blog首页 | Oracle10g与各版本的连通性 »
Oracle10g:v$session_wait_history视图
作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2006/04/10g_session_wait_history.html
为了更有效的保留Session信息，Oracle10g新增加了一个v$session_wait_history视图
该视图用以记录活动Session的最近10次等待事件。
SQL> select event,p1text,p1,p2text,p2,p3text,p3,wait_time
2 from v$session_wait_history where sid=120;EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 WAIT_TIME
---------------------------- -------- -------- --------------- ---------- -------- -- ----------
db file sequential read file# 14 block# 97456 blocks 1 0
row cache lock cache id 11 mode 0 request 3 49
row cache lock cache id 11 mode 0 request 3 0
db file sequential read file# 10 block# 260171 blocks 1 1
db file sequential read file# 14 block# 570536 blocks 1 10
db file sequential read file# 14 block# 6363 blocks 1 12
db file sequential read file# 14 block# 35285 blocks 1 9
db file sequential read file# 14 block# 40674 blocks 1 9
db file sequential read file# 14 block# 69631 blocks 1 1
db file sequential read file# 14 block# 82498 blocks 1 310 rows selected
通过这个视图，Oracle将V$SESSION_WAIT延伸，从而可以获取更多的相关信息辅助数据库问题诊断。
这是Oracle10g中在ASH之外对于等待事件诊断的一个有益小改进。
By eygle on 2006-04-05 16:33 | Comments (0) | Posted to Oracle10g/11g | Edit |Pageviews:
