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

What are the consideration at tehe migration of Oracle 9i to 10G.

Which parameter in Storage clause will reduce no. of rows per block?

What is dictionary cache ?

What is an oracle database schema?

What are the components of SGA?

What is a Rollback segment entry ?

How many Dispatcher Processes are created?

What is meant by redo log buffer ?

What is the significance of having storage clause ?

How will you monitor rollback segment status ?

Why query fails sometimes ?

What does LGWR do?

For more Oracle Architecture Interview Questions Click Here