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 does Space allocation table place within a block ?

What do Redo Log Buffers contain?

What is the function of checkpoint(CKPT)?

How will you monitor the space allocation ?

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

What is an Oracle Rollback Segment?

How to find the SGA Size

What are the functions of SMON?

What are disadvanteges of having raw devices ?

What is the function of Dispatcher (Dnnn)?

How to define Data Block size in Oracle?

What is the maximum number of Lock Processes used?

For more Oracle Architecture Interview Questions Click Here