Recently I was working on using Oracle DBMS_RESOURCE_MANAGER to limit resources usage by read-only queries. This was required to prevent long running ad-hoc and poorly written queries.Instead of writing custom…
If you don't like crsctl status res –t output then try using below :) Can also download here crsstat11g. I have tried this on linux crsctl status res |grep -v "^$"|awk…
Oracle 11gR2 DBMS_STATS introduced useful function report_col_usage to report column usage i.e if column is being used for equality,like predicates. I came to know it while reading Optimizer whitepaper .As per…
Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM and SQL Profiles (using coe_xfr_profile.sql) to fix…
The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact message: Sun Feb 19 12:09:41 2012 Errors in file…
In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this post based on my experiences or any comments on…