SQL>
SQL> ---查询有enqueue等待的事件
SQL> SELECT b.SID, b.serial#, b.username, machine, event, wait_time,
2
CHR (BITAND (p1, -16777216) / 16777215)
3 || CHR (BITAND (p1, 16711680) / 65535) "Enqueue Type"
4FROM gv$session_wait a, gv$session b
5 WHERE a.event NOT LIKE 'SQL*N%'
6 AND a.event NOT LIKE 'rdbms%'
7 AND a.SID = b.SID
8 AND b.SID > 8
9 AND a.event = 'enqueue'
10ORDER BY username;
SIDSERIAL# USERNAMEMACHINEEVENT
WAIT_TIME Enqueue Type
---------- ---------- --------------- -------------- --------------------- ---------- ------------
35
1
bill_db4 enqueue
-1 US
35
1
bill_db4 enqueue
0 US
35
1
bill_db3 enqueue
-1 US
35
1
bill_db3 enqueue
0 US
SQL>
QL>
SQL> SELECT /*+ ORDERED */
2 sql_text
3FROM v$sqltext a
4 WHERE (a.hash_value, a.address) IN (
5
SELECT DECODE (sql_hash_value,
6
0, prev_hash_value,
7
sql_hash_value
8
),
9
DECODE (sql_hash_value, 0, prev_sql_addr, sql_address)
10
FROM v$session b
11
WHERE b.sid= '&sid')
12ORDER BY piece ASC
13/
代入35
SQL_TEXT
----------------------------------------------------------------
UPDATE SMON_SCN_TIME SET SCN_WRP=:1, SCN_BAS=:2, TIME_MP=:3, TIM
E_DP=:4 WHERE TIME_MP = :5AND THREAD = :6AND ROWNUM
|