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

Oracle DBA Journey to Cloud, DevOps and Big Data..

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

Undo Tablespace Sizing

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

In this post I will be discussing various types of Undo extents which can be helpful in determining cause of ORA-30036 i.e unable to extend segment by %s in undo…

Continue ReadingUndo Tablespace Sizing

Sign on Letter to Larry Ellison on AWR and ASH Licensing

  • Post author:Amit Bansal
  • Post published:29 March, 2008
  • Post category:Random
  • Post comments:0 Comments

While surfing across the blog's, I found this particular link, a compaign which is aimed at getting free access to the ASH and AWR reports. I believe most of us…

Continue ReadingSign on Letter to Larry Ellison on AWR and ASH Licensing

HW enqueue contention with LOB

  • Post author:Amit Bansal
  • Post published:28 March, 2008
  • Post category:Performance
  • Post comments:4 Comments

Definition Enqueues are local locks that serialize access to various resources. Enqueue wait event indicates a wait for a lock that is held by another session (or sessions) in an…

Continue ReadingHW enqueue contention with LOB

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

Diagnostics For Database Hang

  • Post author:Amit Bansal
  • Post published:21 March, 2008
  • Post category:Performance
  • Post comments:6 Comments

Many times Oracle DBA's are in a situation when the database is hung and does not seem to be responding. In some scenarios, state is such that you cannot even…

Continue ReadingDiagnostics For Database Hang
  • Go to the previous page
  • 1
  • …
  • 31
  • 32
  • 33
  • 34

Disclaimer!!

This blog reflect our own views and do not necessarily represent the views of our current or previous employers.

The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.

Recent Comments

  • Azure BLOB Storage As Remote Backend for Terraform State File - AskDba.org Weblog on Azure Infrastructure Automation With Terraform: Configuration
  • tolu on 11g: Multiple failed login attempt can block New Application connections
  • venkatesh on Retrieving Database SID,Port information from Grid Control repository
  • Patrick on Solving ORA-1031 while connecting as “/ as sysdba” :
  • Natarajan Gounder on Creating ASM devices on AIX

Trending

  • Resolving Shutdown Immediate Hang Situations
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • MGMTDB: Grid Infrastructure Management Repository
  • User Sessions stuck on resmgr:cpu quantum wait event
  • Using SSL to securely connect to Amazon Redshift Cluster
  • TNS file functionality for PostgreSQL
  • Simplified Approach to Resolve ORA-4031

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 188 other subscribers

Copyright - OceanWP Theme by OceanWP