- 最后登录
- 2015-7-23
- 在线时间
- 39 小时
- 威望
- 158
- 金钱
- 677
- 注册时间
- 2012-4-1
- 阅读权限
- 50
- 帖子
- 115
- 精华
- 0
- 积分
- 158
- UID
- 324
|
1#
发表于 2012-4-1 11:09:52
|
查看: 11204 |
回复: 8
环境:rac节点1
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/product/oracle10g/10.2.0/db
System name: HP-UX
Node name: ynods1
Release: B.11.31
Version: U
Machine: ia64
Instance name: odsdb1
Redo thread mounted by this instance: 1
Oracle process number: 103
节点2类似;
描述:
现象一:
系统有的时候不能创建create table as select * from dual;
有记录的表不能建立,空表倒是能够建立。
现象2;
跑报表的时候,很慢,感觉hang住;
用下面语句查询
要了解哪些数据库用户的会话锁定了对象、锁定的模式是什么、对应的操作系统用户是在哪台计算机上进行操作的、被锁定的对象及其类型等信息
-------------------------------------------------------------------------------------------------------
select s.username,
s.sid,
s.serial#,
decode(lo.locked_mode,
0,
'none',
1,
'null',
2,
'row-s(ss)',
3,
'row-x(sx)',
4,
'share',
5,
's/row-x(ssx)',
6,
'exclusive',
to_char(lo.locked_mode)) mode_locked,
lo.os_user_name,
do.object_name,
do.object_type
from v$session s, v$locked_object lo, dba_objects do
where lo.object_id = do.object_id
and s.sid = lo.session_id;
USERNAME SID SERIAL# MODE_LOCKED OS_USER_NAME OBJECT_NAME OBJECT_TYPE
------------------------------ ---------- ---------- ---------------------------------------- ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------
STATRPT 36 28416 row-x(sx) statrpt OBJ$ TABLE
STATRPT 36 28416 share statrpt BK_PAYMENT_03
现在我只能看到单纯OBJ$是18号对象,被锁住了。type是table。
接下来请问该怎么进一步分析啊? |
|