Presentation Title: Raiders of the Data Dictionary: The Curse of the Buffer Cache
Speaker: Mr Lothar Flatz Oracle ACE OakTable
Company: Diso
Presentation abstract: In the Raiders of the data dictionary series we use the information of the dictionary to improve the physical database design.

I have used the exhaustive knowledge that the database holds about its own structure in many ways

during my ten years with Oracle Consulting. Sometimes when you venture the structures of the dictionary chance does lead you into a nice discovery. As in this case when I found that you can draw a sort of map of an application very quickly querying v$segment_statistics. These map will point out deficiencies in the physical design rather quickly. Once they are resolved, the question of the optimal buffer cache size arises and will be answered.

Presentation begins: 04/12/2016 13:40
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert
Speaker biography:  Lothar Flatz started working with Oracle Database in 1989, in the days of Version 5. He worked for Oracle Corporation for 15 years and was a member of the Real-World Performance Group for two years. He is a member of the OakTable Network of Oracle scientists and specializes in performance tuning.
Related topics: Database: Management & Administration , Database: Performance & Internals
Hall: Hall 7A

UKOUG_Buffer_cache.pdf1.2 MB03/11/2016 17:58:56