Database Best Practices

Best practices from the warehouse database perspective involve the following areas:

• Memory Management

• Storage Requirements

• Backup

• Redo Log Size

• Stats Collection

• The job_queue_processes Parameter

• Access Control