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
Copyright - OceanWP Theme by OceanWP