VMCD.ORG

Focus on database mail:ylouis83#gmail.com

[转] Autotrace with bind variables

Posted by admin on 27th September 2013

JL刚刚写的一篇autotrace与bind variables 的行为:Autotrace trick
之前我们也发现过这个问题具体SR在这里:something seems confused

Tags:
Posted in Oracle Experience | No Comments »

SYSAUX 表空间问题解决

Posted by admin on 19th October 2011

通过awrinfo.sql 以及 v$sysaux_occupants对SYSAUX空间分析,发现OPTSTAT(历史统计信息)相关的表占用近28G,AWR相关占用空间4G多,经分析OPTSTAT的历史
统计信息系统会自动清理失败有如下原因:因为历史统计信息较多,通过DBMS_STATS.PURG[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »