oracle locks query
来源:互联网 发布:微店和淘宝哪个安全 编辑:程序博客网 时间:2024/05/01 17:01
SELECT b.session_id AS sid,
NVL(b.oracle_username, ‘(oracle)’) AS username,
a.owner AS object_owner,
a.object_name,
Decode(b.locked_mode, 0, ‘None’,
1, ‘Null (NULL)’,
2, ‘Row-S (SS)’,
3, ‘Row-X (SX)’,
4, ‘Share (S)’,
5, ‘S/Row-X (SSX)’,
6, ‘Exclusive (X)’,
b.locked_mode) locked_mode,
b.os_user_name
FROM dba_objects a,
v$locked_object b
WHERE a.object_id = b.object_id
ORDER BY 1, 2, 3, 4;
NVL(b.oracle_username, ‘(oracle)’) AS username,
a.owner AS object_owner,
a.object_name,
Decode(b.locked_mode, 0, ‘None’,
1, ‘Null (NULL)’,
2, ‘Row-S (SS)’,
3, ‘Row-X (SX)’,
4, ‘Share (S)’,
5, ‘S/Row-X (SSX)’,
6, ‘Exclusive (X)’,
b.locked_mode) locked_mode,
b.os_user_name
FROM dba_objects a,
v$locked_object b
WHERE a.object_id = b.object_id
ORDER BY 1, 2, 3, 4;
0 0
- oracle locks query
- oracle erp locks info
- Locks in Oracle
- oracle parameters:dml-locks
- Oracle Locks之DML锁
- oracle lock 06 - dml locks
- oracle lock 07 - DDL Locks
- oracle lock 02 - Use of Locks
- oracle lock 04 - Locks and Deadlocks
- oracle lock 05 - overview of Automatic Locks
- Oracle Cursor Query
- About query oracle tablespace
- Oracle Parallel Query
- oracle hierarchical query
- Oracle Parallel Query
- Oracle's Query Transformer
- oracle expdp query(时间)
- oracle+hbn+spring--query
- Secure Apache Configuration
- 字符串按词典分割
- 快速部署zabbix监控服务器
- Why so many Python web frameworks
- hadoop作业引用第三方jar文件
- oracle locks query
- MapReduce的input为SequenceFile的相关实验
- 如何获取客户端真实IP地址
- 更新了android sdk出现aapt问题以及模拟器启动错误
- [职场]14年辞旧迎新
- mysql中的show profiles在5.6.14版本被丢弃
- Split 获取字符串中指定符号分割的字符内容
- 论文写作之不二法则
- mysql中将ip转换为数值的函数