An instance corresponds to an SGA and occupies 80% of the physical memory. sharedpooldatabasebuffercacheredologbufferotherstructures
An instance corresponds to an SGA, which can occupy 80% of the physical memory. shared pooldatabase buffer cacheredo log bufferother structures command sho
An instance corresponds to an SGA, which can occupy 80% of the physical memory.
Shared pool
Database buffer cache
Redo log buffer
Other structures
Run the show sga command to view the SGA
SGA basic unit: granules (10 M. 16 M)
Select componet,
If one background process has one PGA, multiple background processes have multiple PGA
Shared pool:
Store recently executed SQL statements (parsed commands)
Stores recently used data definitions
Two components in the shared pool:
Library cache: stores compiled and parsed SQL statements and PL/SQL statements.
Data dictionary cache: a data dictionary that stores database control information.
Database Buffer Cache:
The basic idea of cache is to store part of the data in the memory.
: Blocks are the basic unit of Oracle storage.
-DB_CACHE_SIZE
-DB_KEEP_CACHE_SIZE
-DB_RECYCLE_CACHE_SIZE
Redo Log Buffer
Stores online redo logs, records database changes, and has a corresponding cache in the memory.
Optional: Large Pool
Processing additional work, such as using rman or parallel processing or IO operations
Option: JAVA POOL
Supports JAVA programming, including JAVA support
PGA:
Each background process has a PGA