Oracle Design Consideration, Index organized tables, partitioned tables, range partition, list partition, hash partition, composite partition
11 House Keeping in Oracle
House keeping in Oracle: invalid optimizer statistics, buffer gets, Disk Reads
10 Oracle Hints to the Database
Oracle SQL performance tuning. using Hints in the database query
08 Considerations while using PLSQL in programming (Oracle)
Considerations while using PLSQL in programming (Oracle)
07 Performance Improvement Consideration
Oracle Performance Improvement Consideration, union vs OR, Union all vs Union, exist vs IN
05 Simple Tuning Rules
Simple Tuning Rules for Oracle. Where vs having, table aliases