HomeОбразованиеRelated VideosMore From: SkillBuilders

Oracle Exadata: Smart Scan in Theory

2 ratings | 947 views
Smart Scan in Theory The first feature I want to look at is Smart Scan. The Smart Scan capability allows the Exadata layer to take over a vast amount of the processing, the workflow to processing SQL, the offload, the workload, from the compute nodes to the cell nodes. What can be offloaded? Row selection and column projection, conventional storage will do block serving. Your session issues a request, the storage system delivers the blocks in database buffer cache all of the dynamic regions of the PGA, and your session then has to filter the rows, extract the columns. With the Smart Scan, the storage tier does not do block serving. The storage tier itself does the row filtering and the column projection and returns only the relevant columns, the relevant rows directly into the PGA of the session that would run the query. We bypass the buffer cache entirely. In addition to that and as part of the Smart Scan, many, many functions can also be evaluated by the cells, so I'll show you a list of which functions can be evaluated shortly.
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.