Answer / cspriyadba

There are 2 basic memory structures on the Oracle Instance

1. System Global Area (SGA)
2. Program Global Area (PGA)

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.

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

Teradata: How can we know the indexed column in a table?

0 Answers   CTS, HSBC,

---

what is the role of archiever

4 Answers   Baidu, Satyam, TCS,

---

What is Dedicated Server Configuration?

2 Answers   IR Consulting,

---

What is User Process?

1 Answers  

---

What is Database Buffers ?

4 Answers  

---

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  

---

When Does DBWR write to the database?

6 Answers  

---

How will you monitor rollback segment status ?

2 Answers  

---

What is the function of checkpoint(CKPT)?

4 Answers  

---

What is the maximum size of a oracle9i database?

1 Answers   Baidu, HCL, TCS,

---

What is the function of Dispatcher (Dnnn)?

4 Answers  

---

How to find the SGA Size

7 Answers   Baidu, Reliance,

---