Suggested list to be added to, deleted from etc
Store your segments in one extent for optimum performance.
Space in an index is never reused.
Full table scans are always bad: use the index.
Seperate tables and indexes for performance reasons.
You should always backup the online redo logs to avoid data loss.
Buffer cache hit ratio should be as high as possible preferably greater than
90%.(from the java tool we use developed in house)
Library Cache hit ratio should be greater than 99% if it isn't increase the
size of the shared pool.(ditto!)
Smallest table should be the driving table for hash joins.
PCTIncrease should be as small as possible but non-zero to minimize
tablespace fragmentation.1% is a good value (from my OCP course notes though
not necessarily given by the tutor!)
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed May 15 2002 - 03:25:21 CDT
