Datacentre Support Reference Guides

Visit our online shop for ALL your parts, components, laptops, electronics and gadgets
 

Oracle: Physical layout goals

 

 
 

This is another one of those lists that I'm going to end up forgetting. Use this as a memory teaser when talking with DBAs or in the unlikely event that I end up as a dba myself.

  1. The database must be recoverable (archive logs, redo logs)
  2. Online redo logs must be mirrored either by the OS or by Oracle
  3. The database I/O weights must be estimated
  4. Contention between LGWR, DBWR, and ARCH must be minimized.
  5. Contention between disks for DBWR must be minimized.
  6. The performance goals for the system must be identified.
  7. The disk hardware options must be known.
  8. The disk mirroring architecture must be known.
  9. Disks must be dedicated to the database.