ORACLE日常维护
-
编辑 删除
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...
-
编辑 删除
ORACLE日常维护脚本！
#！表分析语句exec dbms_stats.GATHER_TABLE_STATS('DBCUSTADM','WUSERFAVCHG',ESTIMATE_PERCENT=>100,cascade=>true);#!通过PID找出执行的语句SELECT /*+ ORDERED */ ...
