Presentation: "Technical - Understanding and Leveraging Oracle 9i Advisories"
Speaker(s): Azeem Mohamed, Quest Software

In Oracle 9i, new features called "Advisories" help a DBA to choose the optimal sizes for the required memory components. There are two advisories for dynamic SGA tuning: the Buffer cache advisory and the Shared ppol advisory. Another advisory relates to the PGA target size. Additionally, there are several new parameters in Oracle 9i that help a DBA to manage the memory structures of Oracle dynamically. This session will investigate the new features of Oracle 9i relative to memory management and give insight on how a DBA can leverage these new available performance options. The listener will learn about the dynamic SGA, new memory measurement units, as well as view SGA statistics, trace resize operations, understand the new advisories, monitor SQL memoery usage, enable automatic SQL memory management and other related memory management information. Specific examples and scripts will be included to highlight use case scenarios of these advisory options.

Speaker Bio:
Azeem Mohamed is a Product Marketing Manager for the Oracle solutions at Quest Software, Inc. He has over 8 years technical experience working with Oracle, holding positions from DBA to Senior Systems Engineer and High Availability Architect. As an Oracle Certified Professional, Azeem has both applied database management experience as well as acquired knowledge from working closely with the many industry experts and speaks often at local Oracle user groups and training conferences. Recently published white papers include "A Successful Performance Tuning Methodology" and "Understanding Oracle 9i Advisories".