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

Performance

Home » Performance » Page 4

Resolving Shutdown Immediate Hang Situations

  • Post author:Saurabh Sood
  • Post published:26 May, 2008
  • Post category:Featured
  • Post comments:7 Comments

Many times Oracle DBA's are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is…

Continue ReadingResolving Shutdown Immediate Hang Situations

Tracing Sessions with Event 10046

  • Post author:Amit Bansal
  • Post published:17 May, 2008
  • Post category:Performance
  • Post comments:0 Comments

10046 Event is used to trace SQL statements (similar to sql_trace=true) with additional details depending on the tracing level which is specified. 10046 EVENT levels: 1 - Enable standard SQL_TRACE…

Continue ReadingTracing Sessions with Event 10046

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

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
  • 2
  • 3
  • 4

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
  • Tweaking _Shared_pool_reserved_min_alloc and ORA - 4031
  • 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