Mohammad Nazmul Huda

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

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
Comments

Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites