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 the maximum number of Lock Processes used?

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

What is meant by redo log buffer ?

What is an Oracle Rollback Segment?

What is PGA?

What are the functions of SMON?

What is the function of checkpoint(CKPT)?

What is Database Buffers ?

How does Space allocation table place within a block ?

What is an Oracle SYSTEM tablespace and when is it Created?

What is the function of Lock (LCKn) Process?

How will you monitor rollback segment status ?

For more Oracle Architecture Interview Questions Click Here