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
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