Library cache:-
stores SQL and PL/SQL statements along with their execution plans.
Data Dictionary Cache:-
stores info about database schema such as tables, columns, definitions, indexes, privileges.
Shared Pool:-
shared memory structures for SQL and PL/SQL execution.
it contains frequently executed SQL statements, execution plans, data dictionary information.
--
buffer memory :- i/o operations happen.
cache memory :- read/write operations happen.
No comments:
Post a Comment