该内容显示了Oracle数据库中会话等待历史的详细信息，主要等待事件包括dbfile sequential read和rowcachelock，涉及文件号、块号、缓存ID、等待时间和模式等关键参数，这有助于进行性能优化和问题排查。
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 3
10 rows selected
扫一扫
4885
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
