How will you monitor the space allocation ?

Question Posted / guest

Answers were Sorted based on User's Feedback

How will you monitor the space allocation ?..

Answer / mohanish sahoo

SQL>desc dba_data_files;
SQL>desc v$tablespace;
SQL>select bytes from dba_data_files where tablespace_name
like 'TABLSPACE_NAME';

Is This Answer Correct ?

4 Yes

0 No

How will you monitor the space allocation ?..

Answer / karthickumar pillaiyarsamy

select sum(bytes) from dba_data_files

Is This Answer Correct ?

0 Yes

0 No

How will you monitor the space allocation ?..

Answer / guest

this can be monitored in DB_data_files

Is This Answer Correct ?

0 Yes

2 No

More Oracle Architecture Interview Questions

How can we plan storage for very large tables ?

What constitute an ORACLE Instance?

What is hit ratio ?

Name the ORACLE Background Process?

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

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

What is a Multi-threaded Server Configuration?

What are Oracle Schema Objects?

What are the two types of Server Configurations?

What is an Oracle Data Segment?

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?

How free extents are managed in Ver 6.0 and Ver 7.0 ?

For more Oracle Architecture Interview Questions Click Here