Chinaunix首页 | 论坛 | 博客
  • 博客访问: 86643
  • 博文数量: 31
  • 博客积分: 25
  • 博客等级: 民兵
  • 技术积分: 280
  • 用 户 组: 普通用户
  • 注册时间: 2011-06-28 06:36
个人简介

还在学习oracle的路上。

文章分类

全部博文(31)

文章存档

2020年(9)

2018年(3)

2017年(6)

2016年(11)

2015年(2)

我的朋友

分类: Oracle

2017-02-17 14:27:17

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#;
--------------查看 锁2
?select ls.osuser os_user_name,
       ls.username user_name,
       decode(ls.type,
              'RW',
              'Row wait enqueue lock',
              'TM',
              'DML enqueue lock',
              'TX',
              'Transaction enqueue lock',
              'UL',
              'User supplied lock') lock_type,
       o.object_name object,
       decode(ls.lmode,
              1,
              null,
              2,
              'Row Share',
              3,
              'Row Exclusive',
              4,
              'Share',
              5,
              'Share Row Exclusive',
              6,
              'Exclusive',
              null) lock_mode,
       o.owner,
       ls.sid,
       ls.serial# serial_num,
       ls.id1,
       ls.id2
  from sys.dba_objects o,
       (select s.osuser,
               s.username,
               l.type,
               l.lmode,
               s.sid,
               s.serial#,
               l.id1,
               l.id2
          from v$session s, v$lock l
         where s.sid = l.sid) ls
 where o.object_id = ls.id1
   and o.owner <> 'SYS'
 order by o.owner, o.object_name;



--------解锁
  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/');
阅读(857) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~