show con_name
/*
CON_NAME
------------------------------
CDB$ROOT
*/
--show pdbs
alter pluggable database orclpdb open;
/*
*/
alter session set container=orclpdb
/*
Session altered.
*/
show con_name
/*
CON_NAME
------------------------------
ORCLPDB
*/
select oracle_username, os_user_name, locked_mode, object_name, object_type
from v$locked_object a,dba_objects b
where a.object_id = b.object_id;
/*
no rows selected
*/
select * from hr.employees;
update hr.employees
set salary=salary+1
where employee_id=100;
/*
1 row updated.
*/
select oracle_username, os_user_name, locked_mode, object_name, object_type
from v$locked_object a,dba_objects b
where a.object_id = b.object_id;
/*
ORACLE_USERNAME OS_USER_NAME LOCKED_MODE OBJECT_NAME OBJECT_TYPE
-------------------- -------------------- ----------- -------------------- --------------------
SYS mike 3 EMPLOYEES TABLE
*/
rollback;
/*
Rollback complete.
*/
select oracle_username, os_user_name, locked_mode, object_name, object_type
from v$locked_object a,dba_objects b
where a.object_id = b.object_id;
/*
no rows selected
*/
