Managing, Optimizing Very Large Databases (VLDBs)

Space management

• Bigfile Tablespaces
• Leveraging data compression
• Using temporary tablespaces effectively
• Implementing partitioning for easy data management
• Making the right choices for partitioned indexes (especially global vs. local)

Memory

• Sizing adequate system global area (SGA), program global area (PGA), and other memory components
•  V$MEMORY_TARGET_ADVICE ,V$SGA_TARGET_ADVICE and V$PGA_TARGET_ADVICE) Enabling parallelism to take advantage of multiple CPUs

For Backup

• Configure fast incremental backups using the block change tracking (BCT) feature