Oracle Performance Tuning

1. Sql-tuning-advisory

2. Oracle wait event

3.Tkprof output understanding:

4.Analyzing awr report in Oracle:

5.Explain plan interpretation:

6.How to find unused indexes

7.Database traces:

6.Oracle database indexes:

7.Oracle Rebuilding Indexes:

8.Oracle Database Table Fragmentation:

9.Long running concurrent request in R12.2:

10.R12.2 forms performance Tunings: