ORACLE DBA Architecture
Shared Pool
- Text of the SQL or PL/SQL statement
- Parsed form of the SQL or PL/SQL statement - Execution plan for the SQL or PL/SQL statements - Data dictionary cache containing rows of data dictionary information Library Cache - shared SQL area - private SQL area - PL/SQL procedures and package - control structures : lock and library cache handles Dictionary Cache - names of all tables and views in the database - names and datatypes of columns in database tables - privileges of all Oracle users SHARED_POOL_SIZE |
|
Background Process
|
|
|
|
HTML Comment Box is loading comments...