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 advantage of having disk shadowing/ Mirroring ?

What is an Oracle Data Segment?

How can you find the size of a database?

What is the OPTIMAL parameter ?

What is User Process?

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?

What is function of RECO?

What is an Integrity Constrains in Oracle?

What is meant by recursive hints ?

How the log writer writes the data into database

When will be a segment released?

What is the maximum number of Lock Processes used?

For more Oracle Architecture Interview Questions Click Here