Note: Burleson Oracle Consulting is the leader in Oracle Emergency Support and is available to assist with any Oracle database problem, anywhere in the world, anytime.

 

Employ Materialized Views Once there was a call from a point-of-sale data warehouse in Germany. The IT manager spoke very little English and most of the conversation was done using Babelfish. The system was largely read-only with a short batch window for nightly updates. Once I connected, I immediately noticed that virtually every query in the system was performing a sum() or avg() function against several key tables. The v$sql_plan view (via plan9i.sql) showed loads of very-large-table, full-table scans, and the system was crippled with “db file scattered read” waits. I was easily able to help by creating three materialized views and employing query rewrite to reduce physical disk I/O by over 2,000 percent; this improved performance by more than 30x — a real silver bullet!       Guarantee your Success! Oracle is the world's most complex, robust and flexible database, considered impossible to master without a mentor. That's why all BC Oracle trainers are working professionals, experts in Oracle who share their tips and secrets.