how oracle will recognise its space is 100gb if 100gb is allocated for it

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> Databases >> Oracle >> Architecture

Question


how oracle will recognise its space is 100gb
 if 100gb is allocated for it...

Question Submitted By :: B.neelu

Rank

Answer Posted By

Re: how oracle will recognise its space is 100gb if 100gb is allocated for it...

Answer
# 1

select bytes/1048576 from dba_free_space where
tablespace_name='';

Is This Answer Correct ?

7 Yes

5 No

Manjeet Kumar

Question	Asked @	Answers
Other Architecture Interview Questions


What are the components of SGA?		5
What are functions of PMON?		5
How will you monitor the space allocation ?		3
What is meant by Redo Log file mirrorring ? How it can be achieved?		1
How to find the SGA Size	Reliance	7
How many Dispatcher Processes are created?		1
Diference between Oracle 9i and 10G.		2
What Does DBWR do?		2
What are disadvanteges of having raw devices ?		1
Why query fails sometimes ?		1
What is Cursor?		2
how oracle will recognise its space is 100gb if 100gb is allocated for it...		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 © 2012 ALLInterview.com. All Rights Reserved.

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