Oracle memory area


Oracle memory area

<<Previous  Next>>

Oracle memory area - May 05, 2009 at 18:00 PM by Rajmeet Ghai

Explain the areas of memory used by oracle, i.e. Software code area, system global area (SGA), program global area(PGA), sort area.

Software area code: - It is a protected location that is used to store oracle code that is supposed to be run. The location is different from users' programs. The software area code is read only and can be shared or nonshared.

System global area: - SGA is used to store data and control information of an Oracles database instance when started. Each instance has its own SGA. SGA is read write. It comprises data structures like Redo buffer, Java pool, Streams pool etc.

Program global area:- PGA contains information about server process. It is a non shared memory when a server process is started. Each process has an exclusive PGA.

Sort area: - SQL work area is typically used for complex queries by memory-intensive operators such as Sort area. A sort operator is used to perform the in-memory sort of a set of rows

Also read

Oracle architecture

Describe Oracle architecture in brief, What is the function of SMON?, Explain different types of segment, Explain SGA memory structures..............

Oracle database tuning

Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory Management - Automatic Shared Memory Management puts Oracle in control of allocating memory within the SGA..........

What is Program Global Area (PGA)?

The PGA is a memory area that contains data and control information for the Oracle server processes. This area consists of the following components:.............

What is a shared pool?

It is the area in SGA that allows sharing of parsed SQL statements among concurrent users............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring