|
接到业务人员的报告,说是报表数据库最近很慢,于是登陆上去检查。结果确意外的发现有一个异常的活动事务:
START_TIME SID SERIAL# SEGMENT_ID SEGMENT_NAME PROCESS SPID SES_ADDR LOCKWAIT USED_UBLK -------------------- ------ ------- ---------- ------------ ------------ ------------ ---------------- ---------------- ---------- 12/30/05 01:48:33 71 20835 19 _SYSSMU19$ 23055 15664 C0000001A45BC4A0 1
START_TIME SID SERIAL# SES_ADDR XIDUSN OWNER -------------------- ------ ------- ---------------- ---------- ------------------------------ OBJECT_NAME -------------------------------------------------------------------------------------------------------------------------------- OS_USER_NAME ORACLE_USERNAME ------------------------------ ------------------------------ 12/30/05 01:48:33 71 20839 C0000001A45BC4A0 19 REPORT WAP_AUTHPRICE_USER_SP_RD report16 REPORT
SID SERIAL# SPID USERNAME TERMINAL PROGRAM ------ ------- ------------ ---------- -------------------- ---------------------------------------- 71 20913 15664 oracle UNKNOWN oracle@rdb01 (TNS V1-V3)
上一篇:SQL Server不能启动的常见故障
下一篇:生产报表数据库出现了活动事务的回滚段损坏(二)
|