v$sqltext

最新推荐文章于 2024-07-15 21:30:27 发布

juliaputao

最新推荐文章于 2024-07-15 21:30:27 发布

阅读量672

点赞数

分类专栏： DATABASE

DATABASE 专栏收录该内容

33 篇文章

订阅专栏

SQL> select sql_text from v$sqltext a where a.hash_value =
  2  (select sql_hash_value from v$session b where b.sid='&sid')
  3  /
Enter value for sid: 113
old   2: (select sql_hash_value from v$session b where b.sid='&sid')
new   2: (select sql_hash_value from v$session b where b.sid='113')

no rows selected

SQL>

SQL> l
  1* select sid,event,p1,p1text from v$session
SQL> / 

       SID EVENT									  P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
	 2 pmon timer									 300 duration
	 3 VKTM Logical Idle Wait							   0
	 4 rdbms ipc message								 300 timeout
	 5 DIAG idle wait								   5 component
	 6 rdbms ipc message								 300 timeout
	 7 rdbms ipc message								 300 timeout
	 8 DIAG idle wait								   5 component
	 9 rdbms ipc message								 300 timeout
	10 rdbms ipc message								 300 timeout
	11 rdbms ipc message								 141 timeout
	12 rdbms ipc message								 100 timeout

       SID EVENT									  P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
	13 smon timer									 300 sleep time
	14 rdbms ipc message							      180000 timeout
	15 rdbms ipc message								 300 timeout
	16 ASM background timer 							   0
	17 rdbms ipc message								 300 timeout
	18 rdbms ipc message								 100 timeout
	19 wait for unread message on broadcast channel 			  1807711440 channel context
	21 SQL*Net message from client						  1650815232 driver id
	22 rdbms ipc message								 500 timeout
	24 SQL*Net message from client						  1413697536 driver id
	25 rdbms ipc message								 300 timeout

       SID EVENT									  P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
	26 rdbms ipc message							       16027 timeout
	27 rdbms ipc message							       16295 timeout
	28 rdbms ipc message								6000 timeout
	29 rdbms ipc message							       14959 timeout
	30 rdbms ipc message							       14001 timeout
	31 rdbms ipc message							       12751 timeout
	32 rdbms ipc message							       10073 timeout
	33 rdbms ipc message							       14068 timeout
	34 rdbms ipc message							       30000 timeout
	35 rdbms ipc message							       30000 timeout
	36 rdbms ipc message							       30000 timeout

       SID EVENT									  P1 P1TEXT
---------- ---------------------------------------------------------------------- ---------- --------------------
	37 rdbms ipc message							       28372 timeout
	38 rdbms ipc message							       28250 timeout
	39 rdbms ipc message							       26123 timeout
	40 rdbms ipc message

11.2以后已经把v$session_wait的内容整合到v$session中，

可以通过v$session /v$session_wait找到等待事件，然后关联v$sqltext 试图通过v$sqltext.hash_value和v$session.sql_hash_value;