ALLInterview.com :: Home Page Forum9.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   interview questions urls   External Links  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
Question 
How to find the SGA Size
 Question Submitted By :: Cspriyadba
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to find the SGA Size
Answer
# 1		 
select * from v$sga;

Fixed Size       72536    bytes 
Variable Size    22900736 bytes 
Database Buffers 409600   bytes 
Redo Buffers     77824    bytes 


Total System Global Area : - Total in bytes of all the sub-
divisions that makes up the SGA. 

Total System Global Area 23460696 bytes
 
1
Cspriyadba
[Trinity Systems]
 
  Re: How to find the SGA Size
Answer
# 2		 
show sga
It shows :
Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
 
0
---
 
 
 
 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
what is ORACLE MEMORY STRUCTURES  1
What constitute an ORACLE Instance?  2
What are the components of SGA?  1
How the space utilisation takes place within rollback segments?  1
What Does DBWR do?  2
Which parameter in Storage clause will reduce no. of rows per block?  1
What is PGA?  3
What do Redo Log Buffers contain?  1
How many Dispatcher Processes are created?  1
What is the significance of having storage clause ?  1
What is Cursor?  2
What is meant by Redo Log file mirrorring ? How it can be achieved?  1
What is a Rollback segment entry ? TCS3
How will you swap objects into a different table space for an existing database?  1
What is the OPTIMAL parameter ?  1
How to find the current session sid  2
What is meant by redo log buffer ?  1
List the factors that can affect the accuracy of the estimations ?  1
What are functions of PMON?  2
List the Optional Flexible Architecture (OFA) of Oracle database ?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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