Advisor Wecast Announcement (16-Sept-2014): Exadata Smart Scan Deep Dive

ADVISOR WEBCAST: Exadata Smart Scan Deep Dive PRODUCT COMMUNITY: Exadata General Schedule: Thursday , September 16, 2014 08:00 AM (US Pacific Time) Thursday , September 16, 2014 11:00 AM (US Eastern Time) Thursday , September 16, 2014 17:00 PM (Central European Time) Thursday, September 16, 2014 22:30 PM (India Standard Time) Abstract: This one-hour session is recommended for technical users who are interested in administering Exadata environments ,help to understand Exadata disk layout and troubleshooting tips for disk replacement issue. Topics Include: We’ll cover topics including:Overview of OffloadingOverview of Smart ScanWhen is this used: TS, IFFS, BIS, BFEffect of compressionCapabilites, Pre-requisites, Verificationv$cell_stateCell_offload_plan_displayWait eventsv$sysstatCell smart table scanCell smart index scanBloom Filter offloadingTracing the cellsrvSIsUse of INSERT ... ORDER BY to increase use of SIs.Why would SIs not be usedMaximum number of SIs per tableWhat happens when mis scn is not moving (effect on SIs)How to disable offloadingColumn ProjectionsPredicate Filtering