-
编辑 删除
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...
-
编辑 删除
Monitoring Transactions and Rollback !
Monitoring Transactions and Rollback by Jeff Hunter, Sr. Database Administrator Contents Overview Is the transaction moving forward or rolling back? How long will it take to rollback a transact...
-
编辑 删除
AIX主机更换损坏的系统盘！
# lsvg -p rootvgrootvg:PV_NAME PV STATE TOTAL PPs FREE PPs &nbs...
-
编辑 删除
ORACLE日常维护脚本！
#！表分析语句exec dbms_stats.GATHER_TABLE_STATS('DBCUSTADM','WUSERFAVCHG',ESTIMATE_PERCENT=>100,cascade=>true);#!通过PID找出执行的语句SELECT /*+ ORDERED */ ...
-
编辑 删除
ORACLE常用的SHELL脚本！
#！管道导出&导入pipe_name=/opt/oracle/full.dmpecho "pipe_name -- ${pipe_name}"/usr/sbin/mknod ${pipe_name} pexp monitor/monitor@crmdb full=y indexes=y buffer=8192000 file=${pipe_name} lo...
-
编辑 删除
IBM系列AIX小型机巡检项目及流程参考
1、机器型号# uname -uMIBM,7029-6E3 IBM,01100550A2、检查系统硬件设备故障灯是否有亮3、系统错误报告# errpt -d H -T PERM //硬件的错误报告IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTI...
