(Oracle tuning is a complex topic. You can write an entire book on tuning, but in order to improve Oracle database performance, every Oracle DBA should follow some basic concepts.
In this introduction, we will briefly introduce the following Oracle topics:
External tuning: we should remember that Oracle does not run alone. Therefore, we will focus on tuning the Oracle server for high performance.
Rowre sequencing reduce disk i/o: we should understand that the most important goal of Oracle tuning is to reduce i/o.
0trace SQL tuning: Oracle SQL tuning is one of the most important areas in Oracle tuning. It is not surprising that some simple SQL tuning rules can greatly improve the performance of SQL statements.)