Oracle 11g Release 1 and Release 2 - How The Instance Process Works?

Objective: To understand how the Oracle processes a query.

Example Query: select * from employees

Applies to Oracle Database 11g or later.

Image:

Oracle 11g Database Instance