Skip to content
AskDba.org Weblog
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g10g Articles
    • 11gLists 11gR1/R2 articles
    • 12c
  • Performance
  • About Us
Menu Close
  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

11gR2

Home » 11gR2

Limiting I/O and CPU resources using 11g Oracle Resource Manager

  • Post author:Amit Bansal
  • Post published:1 September, 2012
  • Post category:11g/Performance
  • Post comments:6 Comments

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…

Continue ReadingLimiting I/O and CPU resources using 11g Oracle Resource Manager

11gr2-Formatted crsctl output

  • Post author:Amit Bansal
  • Post published:11 June, 2012
  • Post category:11g
  • Post comments:1 Comment

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…

Continue Reading11gr2-Formatted crsctl output

Checking column usage information using dbms_stats

  • Post author:Amit Bansal
  • Post published:6 June, 2012
  • Post category:11g/Performance
  • Post comments:2 Comments

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…

Continue ReadingChecking column usage information using dbms_stats

Poll on Sql Plan Management

  • Post author:Amit Bansal
  • Post published:8 May, 2012
  • Post category:11g/Performance
  • Post comments:0 Comments

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…

Continue ReadingPoll on Sql Plan Management

ORA-7445 core dump [kokscold()+849] from EM 12c

  • Post author:Saurabh Sood
  • Post published:20 February, 2012
  • Post category:11g/GRID
  • Post comments:0 Comments

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…

Continue ReadingORA-7445 core dump [kokscold()+849] from EM 12c

11gR2:Listener Startup Issues

  • Post author:Amit Bansal
  • Post published:1 February, 2012
  • Post category:11g
  • Post comments:0 Comments

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…

Continue Reading11gR2:Listener Startup Issues
  • 1
  • 2
  • 3
  • 4
  • 5
  • Go to the next page
Copyright - OceanWP Theme by OceanWP