Oracle Database - Memory

Card Puncher Data Processing


Oracle have two Memory spaces:

Example of configuration changes

With SQLPlus

shutdown immediate
startup nomount
ORACLE instance started.
Total System Global Area | 1570009088 | bytes
Fixed Size               |    2403064 | bytes
Variable Size            |  939525384 | bytes
Database Buffers         |  620756992 | bytes
Redo Buffers             |    7323648 | bytes

alter system set memory_max_target=500m scope=spfile;
alter system set memory_target=500m scope=spfile;
ORACLE instance started.
Total System Global Area |  521936896 | bytes
Fixed Size               |    2404552 | bytes
Variable Size            |  427822904 | bytes
Database Buffers         |   83886080 | bytes
Redo Buffers             |    7823360 | bytes

Discover More
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Card Puncher Data Processing
Oracle Database - ADDM (Automated Database Diagnostic Monitor) - Automatic Performance Diagnostics Tool

ADDM (Automated Database Diagnostic Monitor) is available since Oracle 10g. are useful features for performance tuning and troubleshooting. ADDM reports the most significant performance problems between...
Card Puncher Data Processing
Oracle Database - Data Files

Every Oracle database has one or more physical datafiles (OS File), which contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the...
Card Puncher Data Processing
Oracle Database - Physical I/O

A physical read, I/O of table or index data places the block into the buffer cache. Then we perform a logical io to retrieve the block. Hence, most physical read are immediately followed by a logical io....
Oracle Database Dedicated Server Processes Handling Connections Through The Connection Broker Process
Oracle Database - Pooled Server Architecture

Database resident connection pooling provides a connection pool in the database server for typical Web application usage scenarios in which an application acquires a database connection, works on it for...
Card Puncher Data Processing
Oracle Database - Process global area (PGA) - Work Area

The PGA memory is a memory allocated for each session. The PGA (Program or Process Global Area) is a memory area that stores data and control information for a single server process. It typically contains...
Card Puncher Data Processing
Oracle Database - SORT_AREA_SIZE parameter

SORT AREA SIZE is a parameter which set the sort area size of the pga memory. It will have no effect if the WORKAREA_SIZE_POLICY is set to auto. The sort area size control how much memory will be dynamically...
Oracle Database Sga
Oracle Database - System Global Area - SGA (Shared Memory)

The SGA (System Global Area) is an area of memory allocated when an Oracle Instance starts up. The SGA memory is shared by all sessions connected to Oracle Instance. See A group of shared memory structures...

Share this page:
Follow us:
Task Runner