# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1540117978 -10800
# Node ID adb168e2b3a04e0eb858e7824757f63102c65c47
# Parent  b72b5f7d98ac70d50512d19568b82684d6c7c0a5
List locked objects.

diff -r b72b5f7d98ac -r adb168e2b3a0 oracle.rst
--- a/oracle.rst	Sun Oct 21 13:22:58 2018 +0300
+++ b/oracle.rst	Sun Oct 21 13:32:58 2018 +0300
@@ -334,7 +334,7 @@
 Sessions and locks
 ==================
 
-Select locked objects::
+List locked objects::
 
   select * from v$locked_object;
 
@@ -357,11 +357,29 @@
   from v$locked_object a, v$session b, dba_objects c
   where b.sid = a.session_id and a.object_id = c.object_id;
 
+  select * from DBA_BLOCKERS;
+  select * from DBA_DDL_LOCKS;
+  select * from DBA_DML_LOCKS;
+  select * from DBA_LOCK_INTERNAL;
+  select * from DBA_LOCKS;
+  select * from DBA_WAITERS;
+
 Kill session::
 
   alter system kill session 'SID,SERIAL#';
   alter system kill session '361,565';
 
+List session parameters::
+
+  select * from v$parameter;
+  select NAME, VALUE from v$parameter;
+
+  show parameters ddl_lock_timeout;
+
+Alter session parameter::
+
+  alter session set ddl_lock_timeout = 10;
+
 Installing express edition
 ==========================