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

ora-4031

Home » ora-4031

BUG:10082277: Database Connections failing with ORA-4031

  • Post author:Saurabh Sood
  • Post published:14 July, 2011
  • Post category:11g
  • Post comments:4 Comments

A short write-up on a problem faced in few newly upgraded databases to 11.2.0.1 : I faced this issue in couple of databases which were recently upgraded to 11gR2, the…

Continue ReadingBUG:10082277: Database Connections failing with ORA-4031

Simplified Approach to Resolve ORA-4031

  • Post author:Amit Bansal
  • Post published:21 July, 2008
  • Post category:10g
  • Post comments:11 Comments

After writing few Case studies and other related articles, I will be sharing my approach for Resolving ORA -4031 error. First we will see what ORA-4031 actually means. 04031, 00000,…

Continue ReadingSimplified Approach to Resolve ORA-4031

ORA- 4031 – A Case Study

  • Post author:Amit Bansal
  • Post published:20 June, 2008
  • Post category:10g/Performance
  • Post comments:1 Comment

Today I will be taking up one ORA-4031 issue we faced on one of our client database. Please note that SQL statements mentioned below have been changed and does not…

Continue ReadingORA- 4031 – A Case Study

Application Design and ORA – 4031

  • Post author:Amit Bansal
  • Post published:27 April, 2008
  • Post category:10g/11g/Performance
  • Post comments:1 Comment

Much has been written on designing good application (which uses bind variables) so as to have better performance and avoid shared pool memory issues. Tom Kyte explains this on one…

Continue ReadingApplication Design and ORA – 4031

Tweaking _Shared_pool_reserved_min_alloc and ORA – 4031

  • Post author:Amit Bansal
  • Post published:7 April, 2008
  • Post category:10g/11g/Performance
  • Post comments:5 Comments

Here comes one more article dedicated towards diagnosing ORA- 4031 and related parameters. While googling on ORA-4031 error or working on TAR with Oracle Support you will most likely hit…

Continue ReadingTweaking _Shared_pool_reserved_min_alloc and ORA – 4031

Shared Sub Pools

  • Post author:Amit Bansal
  • Post published:25 March, 2008
  • Post category:10g/11g/Performance
  • Post comments:2 Comments

Today I will discuss about Shared pool subpools which have been introduced in release 9iR2 and higher (To be precise >9.2.0.5) and can be controlled by a hidden parameter "_kghdsidx_count…

Continue ReadingShared Sub Pools
Copyright - OceanWP Theme by OceanWP