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 is a Parallel Server option in ORACLE?

What is meant by redo log buffer ?

What is a Control file ?

What is the maximum size of a oracle9i database?

What constitute an ORACLE Instance?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

Diference between Oracle 9i and 10G.

What is meant by free extent ?

What is meant by Redo Log file mirrorring ? How it can be achieved?

What is an oracle database schema?

Why query fails sometimes ?

What is an Oracle Data Dictionary?

For more Oracle Architecture Interview Questions Click Here