oracle_工作笔记

1、oracle  解锁
-----查看锁
  select l.session_id,sl.serial#,l.locked_mode,l.oracle_username,l.os_user_name,sl.machine,sl.terminal,o.OBJECT_NAME ,sl.logon_time from v$locked_object l,all_objects o, v$session sl
where l.object_id=o.object_id and l.session_id=sl.sid order by sl.sid,sl.serial#;
--------解锁
  alter system kill session ‘sid,serial#’
2、oracle 12C 复制pdb
  create pluggable database pdb2 from pdb1 
file_name_convert =('/opt/oracle/oradata/ZARADB/datafile/pdb1/','/opt/oracle/oradata/ZARADB/datafile/pdb2/');