What is sent from the Oracle database kernel to the Exadata Storage Server using iDB?
A.
Block requests
B.
A command representing the SQL statement
C.
The filtering predicates from the current SQL statement
D.
Statistics on data usage
Explanation:
The database servers and Exadata Storage Server Software communicate using
the iDB – the Intelligent Database protocol. iDB is implemented in the database kernel and
transparently maps database operations to Exadata-enhanced operations. iDB implements a
function shipping architecture in addition to the traditional data block shipping provided by the
database. iDB is used to ship SQL operations down to the Exadata cells for execution and toreturn query result sets to the database kernel. Instead of returning database blocks, Exadata
cells return only the rows and columns that satisfy the SQL query.
http://docs.google.com/viewer?a=v&q=cache:4UC374GVcY8J:www.oracle.com/us/solutions/data
warehousing/039572.pdf+iDB+is+used+to+ship+SQL+operations+down+to+the+Exadata+cells+fo
r+execution+and+to+return+query+result+sets+to+the+database+kernel.&hl=en&gl=in&pid=bl&src
id=ADGEESiqgKeEOT6U3F7g4do169UvHlCnTqonwQHsLhgDdLav7XcSYrG58rzZF4YWtaMwTD
rI8y_HppjlNtyBSDYHE4DzK4yO_hN60xmNyUp71KYKz6kWk0d7TfA1JMytllK_qQeBeyiD&sig=AH
IEtbRT1kn0CvV-dbUuR2EWCCff9Cl6Ag
page 16
B
see: http://www.oracle.com/technetwork/database/exadata/exadata-dbmachine-x4-twp-2076451.pdf page 29
The database kernel determines that Exadata storage is available and constructs an iDB command representing the SQL command issued and sends it the Exadata storage.