Oracle optimization

Great link to optimize your oracle db:

http://youngcow.net/doc/oracle9i/server.920/a96533/stats.htm

If you execute

EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS('OE',DBMS_STATS.AUTO_SAMPLE_SIZE);

your db can go twice as fast.