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 an Oracle Data Block?

What is the function of Dispatcher (Dnnn)?

• What is oracle Architecture?

What are disadvanteges of having raw devices ?

What are Oracle Schema Objects?

What is the use of Oracle Control File?

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

Can a Tablespace hold objects from different Schemes in Oracle?

What is the maximum size of a oracle9i database?

How will you estimate the space required by a non-clustered tables?

What is dictionary cache ?

How to define Data Block size in Oracle?

For more Oracle Architecture Interview Questions Click Here