We all know auto tracle and explain plan. Lets see the uncommon
10g auto tools:
ADDM, Auto stats collection, Sql Tuning Advisor.
AWR collects, processes and maintains performace stats for problem dedection and self tuning.
SGA_TARGET - for tuning caches and pools.
End to End Tracing
trcsess - command line utility, merges trace info into a single file for processing with TKPROF.
11g auto Tools:
Automatic Memory Tuning - MEMORY_TARGET
Resource Manager
Automatic AWR Baselines
Adaptive Metric Baselines
TKPROF:
The TKPROF program converts Oracle trace files into a more readable form
ALTER SYSTEM SET TIMED_STATISTICS = TRUE;
ALTER SESSION SET SQL_TRACE = TRUE;
TKPROF <trace-file> <output-file> explain=user/password@service table=sys.plan_table