ｏｒａｃｌｅ 锁信息查询
[oracle@rac1 ~]$ cat lock_mon.sh
#!/bin/bash
# creator:NinGoo
# function: get sql statement by spid
# parameter: spid
# useage: get_by_spid.sh spid
sqlplus -S /nolog < connect xinnet/H3k#dg5iJ8YdA9g
col SERIAL# format 999999
col sid format 99999
col object_name format a30
col machine format a15
set linesize 1000
set verify off
select object_name,machine,s.sid,s.serial#,l.locked_mode,to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') as login_time from v\$locked_object l,dba_objects o ,v\$session s
where l.object_id=o.object_id and l.session_id=s.sid;
exit;
EOF
[oracle@rac1 ~]$
#!/bin/bash
# creator:NinGoo
# function: get sql statement by spid
# parameter: spid
# useage: get_by_spid.sh spid
sqlplus -S /nolog <
col SERIAL# format 999999
col sid format 99999
col object_name format a30
col machine format a15
set linesize 1000
set verify off
select object_name,machine,s.sid,s.serial#,l.locked_mode,to_char(logon_time,'yyyy/mm/dd hh24:mi:ss') as login_time from v\$locked_object l,dba_objects o ,v\$session s
where l.object_id=o.object_id and l.session_id=s.sid;
exit;
EOF
[oracle@rac1 ~]$
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/90618/viewspace-684607/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
用英文思考问题
请登录后发表评论
登录
全部评论
最新文章
- Oracle Temp 表空间切换
- 一步一步搭建oracle 11gR2 rac+dg之共享磁盘设置(三)
- Oracle dataguard failover 实战
- RMAN restore fails with ORA-01180: can not create datafile 1 (文档 ID 1265151.1)
- oracle process设置的注意事情
- Oracle 11gR2 Active DataGuard配置Step By Step（三）
- Oracle 10g DataGuard物理主备切换-switchover与failover
- oracle 10g dg切换步骤记录
- oracle 10g physical standby 切换操作
- Archiving not possible: No primary destinations errors
