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

Utlbstat and utlestat script

Monitoring DML Table Changes

Statistics Optimizer

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

Page updated

Google Sites

Report abuse