Hotsos Symposium Speaker – Monty Orme
Mr. Orme is a new Hotsos Symposium presenter.
Biography
Mr. Orme has over 16 years of experience with relational database management, including 11 years working for Oracle Corporation. During his tenure with Oracle, he was an instructor and course developer for Oracle University, support analyst for Global Information Technology and Technical Manager for Oracle Consulting Services.
Presentation Title
Performance Benefits of the 11g SQL Result Cache and PL/SQL Function Result Cache
Abstract
Oracle 11g has the ability to cache the results of queries and results of function calls in the Shared Pool. Therefore, repeated executions of a SQL query can retrieve the result set from the SQL Query Result Cache without having to "revisit" all the actual blocks to solve for the answer. Additionally, the Cross-Session PL/SQL Function Result Cache contains the results of function calls for specific combinations of input parameters. Sinse the results are stored in the Shared Pool, and as the name "Cross Session" implies, the results can be reused by any session calling the same function with the same parameters. This paper will describe the management and administration of the SQL Query and PL/SQL Function Result caches, and the performance benefits of both.
Presentation Materials
Presentation materials are available to attendees only. Attendees may find Mr. Orme's presentation at the Hotsos portal. Remember to use your portal login instead of your email address to access the materials.
Schedule
The speaker schedule can be found at the following links: