Okay,

Gonna ask a different way since no one could answer my last post.

What features in Oracle 9i are used by Oracle itself instead of requiring specific application code written to take advantage of the features?

Oracle now claims to be "self" tuning and "self" optimizing but how does it accomplish this????

When installing/creating a db does it require ANY of the following features in order to achieve these new found capabilities?

Oracle Spatial
Oracle Ultra Search
Oracle Data Mining
Oracle OLAP
Example Schema

Oracle JVM
Oracle Intermedia
Oracle Text
Oracle XML DB

Thanks again,
David Miller