GeekInterview.com
Series: Subject: Topic:
Question: 176 of 250

Explain Oracle memory structure.

Asked by: Interview Candidate | Asked on: Apr 29th, 2005
Showing Answers 1 - 3 of 3 Answers
John

Answered On : Mar 26th, 2005

The Oracle RDBMS creates and uses storage on the computer hard disk and in random access memory (RAM). The portion in the computers RAM is called memory structure. Oracle has two memory structures in the computers RAM. The two structures are the Program Global Area (PGA) and the System Global Area (SGA). 
 
The PGA contains data and control information for a single, user process. The SGA is the memory segment that stores data that the user has retrieved from the database or data that the user wants to place into the database.

  
Login to rate this answer.
AJU JOHNSON

Answered On : Apr 29th, 2005

PGA Program global area Contains  
Session variables ,Stack space,Cursor status ,Sort Areas

  
Login to rate this answer.
Sriniv@s..

Answered On : Jun 2nd, 2012

SGA(system global area) & PGA(program global area) are two memory structures in oracle.
SGA::is used to store shared information.It having Buffercache,Redolog buffer,Shared pool,java pool,Larg pool and stream pool.
PGA::is used to store session specific information.i.e sorting,merging information stored in pga.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.