GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Oracle Memory Management Interview Questions


Oracle Memory Management Interview Questions

Questions: 114
Comments: 72
 Oracle Memory Management Tags
 Showing Questions 71-80 of 114 Questions
<< Previous 4 5 6 7 [8] 9 10 11 12 Next >>
 Sponsored Links

 
 Oracle Memory Management Interview Questions
Sorting Options :  

 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 

 Rollback  segment  dynamically  extent  to handle larger transactions entry loads. A  single  transaction may wipeout all available free space in the Rollback Segment 

 By querying DBA_SEGMENT table/view. 
Latest Answer: +This is the view we should use to see the allocation space +Both the views return the same result.=============================================select name,sum(bytes)"allocated space in MB" from dba_data_files/v$datafile==============================================Thanks ...

 Querying the DBA_ROLLBACK_SEGS viewIN USE         - Rollback Segment is on-line.AVAILABLE - Rollback Segment available but not on-line.OFF-LINE  - Rollback 
Latest Answer: The following views help in monitoring rollback segment usage: DBA_SEGMENTSDBA_ROLLBACK_SEGSV$ROLLNAMEV$ROLLSTATV$TRANSACTION ...

List  the  sequence  of  events  when a large transaction that exceeds beyond  its  optimal  value  when  an  entry  wraps and causes the rollback segment to expand into another extend. Transaction Begins. An entry is made in the RES header for new transactions entry Transaction acquires blocks in an extent of RBS The  entry  attempts to wrap into second extent. None is available, so that the RBS must extent. The

 Limit the number of extents in the tableSeparate Table from its indexes.Allocate Sufficient temporary storage. 

 Calculate the total header sizeCalculate the available dataspace per data blockCalculate the combined column lengths of the average rowCalculate the total average row size.Calculate the average number 

It  is  possible  to  use  raw  devices  as data files and what is the advantages over file. system files ?
 Yes. The advantages over file system files. I/O  will  be  improved  because  Oracle  is  bye-passing the kernnel which writing into disk.Disk Corruption 

 Database overall physical architecture is maintained in a file called control file.  It will be used to maintain internal consistency and guide recovery operations. Multiple copies of control 

 Shutdown the databaseCopy one of the existing control file to new locationEdit Config ora file by adding new control file. nameRestart the database. 
Latest Answer: +Before to insert new control files,we should verify the existing control files location+these are the ways to find it=======================================================1.show parameter control_files2.select value from v$parameter where name='control_files'=======================================================+Both ...

View page << Previous 4 5 6 7 [8] 9 10 11 12 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape