ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
What is PGA?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is PGA?
Answer
# 1		 
program global area is used to copy a block from the data
file to the buffer cache. 
two processes are present in the pga:dedicated server
process and the shared server process.
 
Is This Answer Correct ?    0 Yes 1 No
Ravi Dutta
 
  Re: What is PGA?
Answer
# 2		 
Program Global Area (PGA) is a memory buffer that contains 
data and control information for a server process
 
Is This Answer Correct ?    1 Yes 0 No
Pravin Kadam
 
 
 
  Re: What is PGA?
Answer
# 3		 
program global area 
allocated space for server process
 
Is This Answer Correct ?    0 Yes 1 No
Sam
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
What is hit ratio ?  1
What are functions of PMON?  4
What is a Control file ?  2
What is the functionality of SYSTEM table space ?  2
What is the function of ARCH?  1
Which parameter in Storage clause will reduce no. of rows per block?  1
What is PGA?  3
How will you swap objects into a different table space for an existing database?  1
What are the functions of SMON?  2
What is the function of Dispatcher (Dnnn)?  2
What is function of RECO?  1
What is meant by redo log buffer ?  1
When does LGWR write to the database?  3
When will be a segment released?  1
What is the OPTIMAL parameter ? TCS1
How to implement the multiple control files for an existing database ?  1
What are disadvanteges of having raw devices ?  1
Why query fails sometimes ?  1
What does LGWR do?  1
How free extents are managed in Ver 6.0 and Ver 7.0 ? IBM1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com