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

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

Question Posted / b.neelu

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

Answer / manjeet kumar

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

Is This Answer Correct ?

9 Yes

5 No

More Oracle Architecture Interview Questions

How to implement the multiple control files for an existing database ?

What is an oracle database schema?

What is meant by free extent ?

List the factors that can affect the accuracy of the estimations ?

List the Optional Flexible Architecture (OFA) of Oracle database ?

What is the functionality of SYSTEM table space ?

What is the maximum number of Lock Processes used?

What is Dedicated Server Configuration?

What is the function of Dispatcher (Dnnn)?

What is an Oracle Data Block?

How can we plan storage for very large tables ?

What are functions of PMON?

For more Oracle Architecture Interview Questions Click Here