- 博客(8)
- 收藏
- 关注
RSS订阅转载 get_blocker_lock.sql
set pagesize 2000col sess format a20break on id1 skip 1 SELECT DECODE(request,0,'Holder: ',' Waiter: ')||inst_i...
2009-06-16 16:40:53
131
转载 查询数据库登陆用户的当前环境！
select SYS_CONTEXT('USERENV','TERMINAL') terminal, SYS_CONTEXT('USERENV','LANGUAGE') language, SYS_CONTEXT('USEREN...
2009-06-09 18:02:48
147
转载 dbms_backup_restore恢复包！
DECLAREdevtype varchar2(256);done boolean;BEGINdevtype:=sys.dbms_backup_restore.deviceAllocate(type=>'',ident=&...
2009-05-19 10:52:33
187
转载 Monitoring Transactions and Rollback !
Monitoring Transactions and Rollback by Jeff Hunter, Sr. Database Administrator Contents Overview Is t...
2009-03-11 16:42:11
145
转载 AIX主机更换损坏的系统盘！
# lsvg -p rootvgrootvg:PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTIONhdisk0...
2009-01-15 18:20:16
224
转载 ORACLE日常维护脚本！
#！表分析语句exec dbms_stats.GATHER_TABLE_STATS('DBCUSTADM','WUSERFAVCHG',ESTIMATE_PERCENT=>100,cascade=>true);...
2009-01-15 17:59:01
104
转载 ORACLE常用的SHELL脚本！
#！管道导出&导入pipe_name=/opt/oracle/full.dmpecho "pipe_name -- ${pipe_name}"/usr/sbin/mknod ${pipe_name} pexp ...
2009-01-15 17:55:26
189
转载 IBM系列AIX小型机巡检项目及流程参考
1、机器型号# uname -uMIBM,7029-6E3 IBM,01100550A2、检查系统硬件设备故障灯是否有亮3、系统错误报告# errpt -d H -T PERM//硬件的错误报告IDENTIFIER T...
2009-01-15 17:46:14
600
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人