woensdag 9 april 2008

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.

Geen opmerkingen: