Several aspects of Oracle Optimization:
- External adjustment: We should remember that Oracle is not running alone. So we will see a high performance by adjusting the Oracle server. <
Usually said hardware performance>
- Row Re-Sequencing to reduce disk I / O: We should understand that Oracle Tuning is the most important goal to reduce I / O. <
Debris is also one of them>
- Oracle SQL adjustment. Oracle SQL Adjustment is one of the most important fields in Oracle adjustment, as long as some simple SQL tuning rules can greatly enhance the performance of SQL statements, this is not surprising. <
Popularly do a SELECT SQL requires faster and more accurate>
- Adjust Oracle Sort: Sorting for Oracle performance is also very affected. <
Sort parameters, SQL forced sorting, do not know that the drive table is forced to retrieve this type of adjustment>
- Adjust Oracle's competition: The parameter settings of the tables and indexes have a big impact on the performance of Update and Insert.
I don't know what else needs to learn optimization.
