Oracle's V$ Views

Oracle's V$ Views

Working with large (REALLY Large) Datasets

http://www.devshed.com/c/a/Oracle/Large-Database-Features-In-Oracle/

Appropriate Transaction Isolation Level

Proper Indexing

http://en.wikipedia.org/wiki/Index_(database)

http://www.dba-oracle.com/art_dbazine_idx_rebuild.htm

http://www.dba-oracle.com/oracle_tips_blocksizes-.htm

Caching & Pooling