SQL Offload and BUFFER_GETS
While investigating a question posed by my colleagues recently I noticed that SQL which is offloaded to Exadata storage cells for processing returns an unusually high value for buffer gets. Here is an example:
PLAN_TABLE_OUTPUT--------------------------------------------------------------------------------------------SQL_ID d8sc6kj0zm89p, child number 0-------------------------------------select /* sql_offload_test_3 */ * from cs_message_log wheretext like 'Successfully Saved Report%'Plan hash value: 137315785--------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |--------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | | | 304K(100)| ||* 1 | TABLE ACCESS STORAGE FULL| CS_MESSAGE_LOG | 32839 | 11M| 304K (1)| 01:00:54 |--------------------------------------------------------------------------------------------Predicate Information (identified by operation id):---------------------------------------------------1 - storage("TEXT" LIKE 'Successfully Saved Report%')
0