© 2008 Julian Dyke juliandyke.com 60 Application Design Inter-Instance Messages Minimize use of DROP and TRUNCATE Require inter-instance synchronization to invalidate block ranges in buffer caches DELETE may be more efficient for small tables Use Global Temporary Tables where possible Avoid using parallel query in OLTP workloads Parallel queries read blocks directly into local buffers Require inter-instance synchronization to ensure dirty blocks in remote buffer caches are flushed back to disk Optimizer may not consider synchronization costs when selecting a parallel execution plan
{}