Index

Physical Database Design

• Considering Synthetic Keys and Reverse Key Indexes
• Considering Nulls and Indexes
• Considering Partitioning
• Considering Introduced Redundancy (Denormalization)
• Considering Introduced Meta-Data
• Declare NOT NULL constraints
• Specify scale for NUMBERs
• Consider table column order

Database Creation

• Use raw log files
• Use raw tempfiles
• Avoid buffered I/O
• Use asynchronous I/O
• Database block size = file system buffer size
• Use a large database block size
• Use large (direct) multiblock reads
• Finding the maximum effective multiblock read count
• Disk Configuration for Sequential Scans
• Disk Configuration for Parallel Table Scans
• Disk Configuration for Pseudo-Random Reads
• Disk Configuration for Pseudo-Random Writes
• Disk Configuration for Online Log Files
• Disk Configuration for Archived Log Files
• Disk Configuration for Temporary Tablespaces
• Disk Configuration for Rollback Segments
• Planning Tablespaces
• Planning Datafiles
• Planning Extents
• Customizing SQL.BSQ

Database Server Tuning

• Note the db_block_checksum parameter setting
• Consider event 10359 for NOLOGGING LOBs
• Calculating the Cache Hit and Miss Rates
• Tuning the Log Buffer Size
• Redo Latch Tuning
• Tuning Log Switches
• Archiver Tuning
• Disk Load Balancing
• Tuning the _row_cache_cursors Parameter

Database Administration

• Avoiding ORA-1555 (Snapshot Too Old) Errors
• Don't Kill That Process - Suspend It!
• Cleaning Up Stray Temporary Segments

© Ixora Pty Ltd.   All rights reserved. 12-Oct-2007 22:22