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 51-60 of 114 Questions
<< Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
 Sponsored Links

 
 Oracle Memory Management Interview Questions
Sorting Options :  

 The data dictionary cache is stored in an area in SGA called the Shared SQL Pool.  This will allow sharing of parsed SQL statements among concurrent users. 

 It is area in memory that is used by a Single Oracle User Process. 

 Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. 

 Due to insufficient Shared SQL pool size. Monitor   the ratio of the reloads takes place while executing SQL statements.   If   the   ratio   

 Database buffers are cache in the SGA used to hold the data blocks that are read  from  the  data  segments in the database such as tables, indexes and clusters DB_BLOCK_BUFFERS 

 Dictionary  cache is information about the databse objects stored in a data dictionary table. 

 Number  of  times processes repeatedly query the dictionary table is called recursive  hints.  It  is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE 

 Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before  writing  them  into  

 Export the user Perform import  using  the  command  imp  system/manager   file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop 
Latest Answer: If its the same database use:alter table the_table move tablespace other_tablespace; alter index the_index rebuild tablespace other_tablespace; ...

List the Optional Flexible Architecture (OFA) of Oracle database? or How  can  we  organize  the  tablespaces in Oracle database to have maximum performance ?
 SYSTEM - Data dictionary tables.DATA  - Standard operational tables.DATA2- Static tables used for standard operationsINDEXES - Indexes for Standard operational tables.INDEXES1 - Indexes of static 

View page << Previous 2 3 4 5 [6] 7 8 9 10 11 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 (?)

 
Expert Members
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

 
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