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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   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
How the space utilisation takes place within rollback 
segments?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How the space utilisation takes place within rollback segments?
Answer
# 1
It  will  try  to  fit  the transaction in a cyclic fashion
to all existing extents.  Once it found an extent is in use
then it forced to acquire a new extent (No. of extents is
based on the optimal size)
 
Is This Answer Correct ?    0 Yes 0 No
Orawhiz
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
How does Space allocation table place within a block ?  1
How to find the current session sid  2
What is a Rollback segment entry ? TCS3
What is the function of Lock (LCKn) Process?  1
Name the ORACLE Background Process?  2
What is User Process?  1
What is the maximum number of Lock Processes used?  1
Why query fails sometimes ?  1
What is hit ratio ?  1
How to find the SGA Size  2
How free extents are managed in Ver 6.0 and Ver 7.0 ? IBM1
What is the function of ARCH?  1
What do Redo Log Buffers contain?  1
What is the role of PCTFREE parameter is Storage clause ?  2
What is a Parallel Server option in ORACLE?  1
How will you force database to use particular rollback segment?  1
List the factors that can affect the accuracy of the estimations ?  1
What is the OPTIMAL parameter ? TCS1
What is meant by recursive hints ?  1
What is a Multi-threaded Server Configuration?  1
 
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