List locked objects.
--- 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
==========================