Presentation Title: My Query Plan Says Table Access Full: What Happens Next?
Speaker: Mr Roger MacNicol
Company: Oracle
Presentation abstract: For some reports the fastest way to get them done is to use an index to go straight to the rows of interest, but sometimes the only way that makes sense is to scan the entire table. I'm the Oracle Architect for Smart Scan and the engineer in Oracle co-responsible for the table scan driver and this talk will show what happens under the covers in simple easy to understand steps. We will look at (1) what is a granule in PQ (2) how exactly does the system decided whether to use buffer cache to direct read, (3) how is physical I/O done including Multi-Block reads and Async-I/O (4) what wait events and stats to look at (5) what tuning options are available to the DBA, and (6) for the truly curious how to trace what is happening.
Presentation begins: 03/12/2017 13:40
Presentation duration: 50
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert, Product User
Speaker biography:  I have been working on developing core database functionality for over 30 years. In the late 90's I was query engine architect for Sybase IQ columnar database and the first Chair of the TPC-H subcommittee. I've been at Oracle since 2005, first 2 years in Data Guard and since then working as an Architect on Table Scans, Compression, and Smart Scan in the Data Storage Tech group.
Related topics: Database: 12c Database
Hall: Media Suite

UKOUG_Storage_Access_Full_Final.pdf1018 KB08/12/2017 22:43:16