What is sent from the Oracle database kernel to the Exadata Storage Server using iDB?

What is sent from the Oracle database kernel to the Exadata Storage Server using iDB?

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 to

return 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



Leave a Reply 1

Your email address will not be published. Required fields are marked *