How about: Keep re-analyzing your tables and indexes. Run gather_statistics (or whatever) all the time.

Bobak, Mark wrote:

I think this subject has been done to death. We should talk about less contentious issues such as:

- The buffer cache hit ratio, your friend in expert Oracle tuning!
- Rebuild your tables regularly to reduce the number of extents and improve 
performance!
- Disk access is at least 10,000x slower than memory, to tune your database, eliminate 
physical I/O!

Anyone else got and good ones? ;-)

-Mark

-----Original Message-----
Sent: Wednesday, December 10, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L




BTW, does anyone know what a rocket scientist refers to when they say "Hey,
this is all quite easy, it sure ain't ?????" ?


Cheers ;)

Richard



Surely the Rocket Scientist version must be "Hey, this is all quite easy, it sure ain't index rebuilding"


<very evil grin>

Ciao
Fuzzy
:-)



-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to