|
Top Tuning Tips: Avoid
unplanned full table scans, Use only selective indexes, Manage multi-table
joins, Manage statements containing views, Tune sub-queries, Manage large
table accesses, Revisit the whole tuning process.
10.7 generally requires 20%
- 30% larger SGA than 10.6 regardless of App.
An unnamed source at Oracle
has been quoted with the statistic that an On Line Transaction Processing
Database will grow at 30% per year and Oracle has observed this rate
consistently for the last 5 years. Many Applications projects run out of
space in year two from their initial configuration.
In $AD_TOP/sql there is a
script adcompsc.pls which is the best script to compile all invalid
objects. You may need to copy this and modify this to compile all invalid
objects at once.
|
