全部博文
-
编辑 删除
get_blocker_lock.sql
set pagesize 2000col sess format a20break on id1 skip 1 SELECT DECODE(request,0,'Holder: ',' Waiter: ')||inst_id || ':' || sid sess, id1, id2, lmode, request...
-
编辑 删除
查询数据库登陆用户的当前环境！
select SYS_CONTEXT('USERENV','TERMINAL') terminal, SYS_CONTEXT('USERENV','LANGUAGE') language, SYS_CONTEXT('USERENV','SESSIONID') sessionid,SYS_CONTEXT('USERENV','INSTANCE') instance,SYS_CONTEXT('USER...
-
编辑 删除
dbms_backup_restore恢复包！
DECLAREdevtype varchar2(256);done boolean;BEGINdevtype:=sys.dbms_backup_restore.deviceAllocate(type=>'',ident=>'T1');sys.dbms_backup_restore.restoreSetDatafile;sys.dbms_backup_restore.restoreControlfi...
