Search this site
Mohammad Nazmul Huda
  • About Me
  • Certifications
  • Publications
  • Study Resources
  • Training
  • Technical Docs
    • Oracle
      • Managing Database
      • Cloud Control
      • Backup and Recovery
      • Performance Tuning
      • SQL Functions
      • Database Change
      • Replication
      • ASM
      • BACKUP AND RECOVERY
      • 12c Issues
      • RMAN
      • Data Guard
      • Bugs
      • LISTENER
      • OCM
      • ORA ERROR
      • SQL
      • PL/SQL
      • Parameters
      • Scripts
      • Security
      • Tools
      • Database Backup
    • SQL SERVER
    • Teradata
    • MySQL
    • Azure SQL Database
    • PostgreSQL
    • Linux
    • AWS
    • Data Science
  • Other
  • Contact
Mohammad Nazmul Huda

Performance Tuning

Buffer Cache Tuning

Redo Log Buffer Tuning

Shared Server Tuning

Shared Pool Tuning

Partition Table

Dealocate Unused Extent

ADDM (Automatic Database Diagnostic Monitor)

Automatic Shared Memory Management(ASMM)

Automatic Workload Repository (AWR)

Materialized View

Row Chaining

Sort Tuning

LOC Resolve

Utlbstat and utlestat script

Monitoring DML Table Changes

STATSPACK

Statistics Optimizer

Cluster

Check the reason for Wait for Particular SQL

List of all Wait events in Oracle 11g

Classes of Wait Events

How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues

Oracle Enqueues

Refresh session is waiting for enq: JI - contention

enq: SQ – contention

Delete taking long time for no index on referential Integrity Constraint

Troubleshooting mutex X/S Due to High Version Count

How Does an execution plan can suddenly change in Oracle for Statistics

Oracle SQL Tuning with function-based index TRUNC

Oracle choosing bad executing plan for wrong cardinality Estimation and use Oracle Dynamic sampling or SQL Profile to improve better execution plan

Report abuse
Page details
Page updated
Google Sites
Report abuse