本帖最后由 zhaobin81-pb 于 2012-2-6 09:00 编辑
awr快照无法生成
能帮着看下吗
SYS@west1> edit
已写入 file afiedt.buf
1 select t2.username, t2.sid, t2.serial#, t2.logon_time
2 from v$locked_object t1, v$session t2
3 where t1.session_id = t2.sid
4* order by t2.logon_time
SYS@west1> /
USERNAME SID SERIAL# LOGON_TIME
------------------------------ ---------- ---------- --------------
983 5211 06-2月 -12
SYS@west1> select * from v$lock where sid = 983;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
00000002596398D8 00000002596398F8 983 WF 0 0 4 0 16979 2
0000000259639B78 0000000259639B98 983 WF 70 0 6 0 16976 2
0000000259639F68 0000000259639F88 983 WF 56 0 6 0 16976 2
000000025963A568 000000025963A588 983 WF 15 0 6 0 16976 2
000000024F5C8ED8 000000024F5C8F00 983 TM 8943 0 3 0 16976 2
000000024F7F46D8 000000024F7F4710 983 TX 327699 109838 6 0 16976 2
已选择6行。
SYS@west1> select event from v$session_wait where sid = 983;
EVENT
----------------------------------------------------------------
gc cr request
SYS@west1> edit
已写入 file afiedt.buf
1 select t2.username, t2.sid, t2.serial#, t2.logon_time, t2.paddr, t1.object_id
2 from v$locked_object t1, v$session t2
3 where t1.session_id = t2.sid
4* order by t2.logon_time
SYS@west1> /
USERNAME SID SERIAL# LOGON_TIME PADDR OBJECT_ID
------------------------------ ---------- ---------- -------------- ---------------- ----------
983 5211 06-2月 -12 000000025BC1F8B8 8943
SYS@west1> select object_name from dba_objects where object_id = 8943;
OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
WRH$_SQL_BIND_METADATA
SYS@west1> select spid from v$process where addr = '000000025BC1F8B8';
SPID
------------
23396
[root@db1 ~]# ps -ef | grep 23396
oracle 23396 1 0 04:00 ? 00:00:16 ora_m000_west1
kill 掉m000就恢复正常
10.2.0.5(rac)