While installing Oracle 9.2, I notice the banner says

"Easier and Cheaper to Manage:
- Self Tuning Memory
..."

I wonder to what degree it tunes itself? Can it tune optimally by itself?