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

The correct answer is C. The filtering predicates from the current SQL statement. 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…

Smart Scan Technology

Question

Options

ABlock requests
BA command representing the SQL statement
CThe filtering predicates from the current SQL statement
DStatistics on data usage

How the community answered

(64 responses)

A
5% (3)
B
11% (7)
C
81% (52)
D
3% (2)

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.

Topics

#iDB protocol#filtering predicates#storage offloading#SQL processing

Community Discussion

No community discussion yet for this question.

Full 1Z0-536 Practice