Check out these diagrams of the Oracle 8i and 9i database architecture. They are courtesy of Mark Fuller of Oracle. Whenever, I have a question about designing and tuning a database, I refer to these diagrams. I just wish I had a large format printer.

Oracle 8i Architecture
Oracle 9i Architecture

I really am working on some more Oracle code. Check back in about a month.

Free counters provided by Andale.