Interested to Buy Any Domain ? << Click Here >> for more details...
what is ORACLE MEMORY STRUCTURES
- 3 Answers
- 9020 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / cspriyadba
There are 2 basic memory structures on the Oracle Instance
1. System Global Area (SGA)
2. Program Global Area (PGA)
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / azhar505@gmail.com
Oracle Instance is a combination of memory and background processes.
Types of memory strucutres.
1.SGA(Shared Global Area):This is chunk of memory allocated during instance startup.SGA contains data and control information for an oracle instance.SGA is shared by several background processes.
SGA contains
SHAREDPOOL,Database BufferCache,LogBuffer Cache.
JavaPool and Large Pool are optional memory structures.
2.PGA(Program or Private global Area):
Contains data and control information for each server processes.Unlike SGA,PGA is not shareable.There is one PGA for one server process.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
ORACLE MEMORY STRUCTURES
software code area:-software code area are partitions of
memory used to store code that is being or may be executed.
system global area:-it is a group of shared memory
structures that contain data and control information for one
oracle database instance
database buffer cache
redo log buffer
shared pool
program global area:-it is a memory region that
contains data and control information for server process
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the function of Redo Log in Oracle?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is hit ratio ?
Which parameter in Storage clause will reduce no. of rows per block?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is an Oracle Data Dictionary?
What are the uses of Oracle Rollback Segment?
What do Redo Log Buffers contain?
How to define Data Block size in Oracle?
What is Dedicated Server Configuration?
How to find the SGA Size
what is the role of archiever
Oracle General 
