- 博客(4)
- 收藏
- 关注
原创 Sql Tuning Advisor
从oracle 10g开始,oracle推出了自己的SQL优化工具,即使用DBMS_SQLTUNE包。执行DBMS_SQLTUNE包需要授权advisor。 创建任务 declare task_name varchar2(300); tune_sqltext CLOB; begin tune_sqltext := 'SQL文本'; task_name :
2012-03-29 14:46:55 810
原创 Enabling Tracing in Your Application
If you own the source code to theapplication you wish to trace, it might be feasible for you to modify the codedirectly to enable SQL Trace. This can be advantageous because you can enableSQL Trace at
2012-03-28 10:46:44 590
原创 ORACLE_OCM.MGMT_CONFIG_JOB_2_2 ORA-12012
alert文件报错 ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_2" ORA-29280: invalid directory path ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436 ORA-06512: at line 1 s
2012-03-27 09:16:26 4151
原创 drop_caches(释放内存)
Writing to this will cause the kernel to drop clean caches, dentries and inodes from memory, causing that memory to become free. To free pagecache: * echo 1 > /proc/sys/vm/drop_caches To free dentr
2012-03-12 11:06:13 1342
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人