Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
SGA |
System Global Area (SGA) Group of shared memory structures that tore data and manage information for a single database instance.
|
|
PGA |
Program Global Area (PGA) Stores data and manages information for a server process or background process.
|
|
Database buffer cache |
Stores copies of data blocks read from data files and waiting to be written to data files. |
|
REDO LOG BUFFER |
Circular buffer that stores all changes made to the DB Can reconstruct DDL or DML operations
|
|
SHARED POOL |
"Catch all" Bucket: shared SQL, data dictionary cache etc
|
|
Large Pool: |
Stores memory allocations that are larger than the shared pool can handle (overflow)
|
|
Java pool |
Stores session-specific Java code within the JVM |
|
Strams pool: |
Used in Oracle Streams database replication |
|
Fixed SGA |
Internal housekeeping area (locks processes etc) |
|
DDL |
Data Definition Language data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas. examples Create Alter Drop
|
|
DML |
Data Manipulation Language used for selecting, inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML |
|
PGA |
PROGRAM GLOBAL AREA The PGA (Program or Process Global Area) is a memory area (RAM) that stores data and control information for a single process.
|
|
SESSION MEMORY |
Logon information and session related data |
|
Private SQL area |
Query execution work data |
|
restricting the PGA size |
PGA_AGGEGATE_LIMIT initialization parameter |