SUNDAY, AUGUST 14, 2011Determine HWM and reduce it by shrink spaceAfter I reviewed "Oracle Database 11g Performance Tuning Recipes A Problem-Solution Approach" book. That helped me interest much about Oracle Database Performance Tuning and what Oracle DBA s...【阅读全文】
ORACLE 常见系统包及常用方法一、dbms_metadata.get_ddl:生成数据库对象的ddl信息:1)获得表、索引、视图、存储过程、函数的DDLselectdbms_metadata.get_ddl('TABLE','T','SCOTT') from dual;selectd...【阅读全文】
1:使用vmstat和top查看系统cpu,io,内存使用情况2:查看当前状态下存在的等待事件select sid,event,p1,p2,seconds_in_wait from v$session_wait where event not like '%SQL%' and event not like 'rdbms%' and event not like '%message%' and event not like '%Streams AQ%' AND EVENT NOT LIKE '%slave%' order by e...【阅读全文】