Skip to content

AskDba.org Weblog

  • Home
  • Forums
    • DBA – Wiki
    • Database Administration
    • Real Application Cluster
    • Automatic Storage Management
  • AWS
  • Azure
  • Oracle
    • 10g
    • 11g
    • 12c
  • Performance
  • About Us

Performance

This section lists down Performance Tuning articles

  • Limiting I/O and CPU resources using 11g Oracle Resource Manager
  • Checking column usage information using dbms_stats
  • Poll on Sql Plan Management
  • Optimizer Choosing Nested-Loop Joins Instead of Hash-Joins
  • Plan Stability using Sql Profiles and SQL Plan Management
  • V$SQL_SHARED_CURSOR in 11.2.0.2
  • 11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
  • dbms_stats.copy_table_stats does not alter low/high value
  • Index Access best approach?? Not Always…
  • 11g New Feature: Database Replay
  • ORA- 4031 – A Case Study
  • Tracing Sessions with Event 10046
  • Application Design and ORA – 4031
  • Tweaking _Shared_pool_reserved_min_alloc and ORA – 4031
  • HW enqueue contention with LOB
  • Shared Sub Pools
  • Diagnostics For Database Hang

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

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
  • Prabhav Pushkar on MGMTDB: Grid Infrastructure Management Repository
  • 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” :
Trending
  • Resolving Shutdown Immediate Hang Situations
  • Identifying PostgreSQL Bloat and fixing it without downtime
  • Simplified Approach to Resolve ORA-4031
  • LGWR terminating instance due to error 338
  • Allocation Unit and Extents In ASM
  • How To Recover From Corrupted OCR Disk
  • Querying RDS PostgreSQL logs using Amazon Athena
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
Proudly powered by WordPress | Tech Blog WordPress Theme by TheMagnifico
TOP