v$session_wait

最新推荐文章于 2021-04-07 22:51:49 发布

EVISWANG

最新推荐文章于 2021-04-07 22:51:49 发布

阅读量1k

点赞数

分类专栏： v$ package

本文链接：https://blog.csdn.net/EVISWANG/article/details/50380216

版权

v$ package 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

<pre name="code" class="sql">SQL> col event for a35
SQL> select sid,event,p1,p1raw from v$session_wait where event not like 'SQL*Net%';

       SID EVENT				       P1 P1RAW
---------- ----------------------------------- ---------- ----------------
	 6 db file sequential read			3 0000000000000003
	 8 Space Manager: slave idle wait		2 0000000000000002
	35 Space Manager: slave idle wait		0 00
	36 Space Manager: slave idle wait		3 0000000000000003
	67 pmon timer				      300 000000000000012C
	70 jobq slave wait				0 00
	73 Space Manager: slave idle wait		5 0000000000000005
       100 rdbms ipc message			      100 0000000000000064
       103 Space Manager: slave idle wait		7 0000000000000007
       108 jobq slave wait				0 00
       133 VKTM Logical Idle Wait			0 00
       140 Space Manager: slave idle wait		1 0000000000000001
       166 rdbms ipc message			      300 000000000000012C
       167 rdbms ipc message			      500 00000000000001F4
       199 DIAG idle wait				5 0000000000000005
       205 Space Manager: slave idle wait		6 0000000000000006
       232 rdbms ipc message			      300 000000000000012C
       235 db file scattered read			5 0000000000000005
       265 DIAG idle wait				5 0000000000000005
       273 Space Manager: slave idle wait		8 0000000000000008
       298 rdbms ipc message			      300 000000000000012C
       331 rdbms ipc message			      300 000000000000012C
       337 Space Manager: slave idle wait		9 0000000000000009
       364 rdbms ipc message			      283 000000000000011B
       397 rdbms ipc message			      300 000000000000012C
       430 rdbms ipc message			       91 000000000000005B
       431 rdbms ipc message			      300 000000000000012C
       437 jobq slave wait				0 00
       463 rdbms ipc message			      300 000000000000012C
       496 smon timer				      300 000000000000012C
       529 rdbms ipc message			   180000 000000000002BF20
       530 Streams AQ: qmn slave idle wait		1 0000000000000001
       562 rdbms ipc message			      300 000000000000012C
       564 Streams AQ: waiting for time manage		0 00
	   ment or cleanup tasks

       595 rdbms ipc message			      100 0000000000000064
       694 jobq slave wait				0 00
       729 read by other session			3 0000000000000003
       760 Streams AQ: qmn coordinator idle wa		0 00
	   it

       766 Space Manager: slave idle wait		4 0000000000000004

39 rows selected.

SQL>

EVISWANG

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
v$session_wait

SQL> select sid,event,p1,p1raw from v$session_wait where event not like 'SQL*Net%'; SID EVENT P1 P1RAW---------- ---------------------------------------------------------------- --
复制链接

扫一扫

专栏目录