Summary

In this information-packed Webinar, Oracle expert Don Burleson offers a practical, pragmatic approach to SQL tuning, from his unique perspective as a seasoned Oracle professional. Topics covered include

• the goals of SQL tuning, from replacing unnecessary, large full-table scans to caching small-table, full-table scans
• common causes of unnecessary full-table scans;
• how to plot index usage over time (including scripts to help you do so); and more.

Don’s  fast-paced presentation underscores his message that Oracle 10g’s AWR will revolutionize SQL tuning by greatly simplifying execution plans, enabling you to predict changes in SQL access before they cripple your database, and build a platform for Al-based database tuning.

View the Webinar »

Bio

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience. He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems. A former Adjunct Professor, Don Burleson has written 15 books, published more than 100 articles in national magazines, serves as Editor-in-Chief of Oracle Internals and edits for Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences. Don’s Web sites include DBA-Oracle, Remote-DBA, Oracle-training, remote support and remote DBA.