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

What is Shared SQL Area?

What constitute an ORACLE Instance?

How does Space allocation table place within a block ?

Which parameter in Storage clause will reduce no. of rows per block?

How to find the SGA Size

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

What is an Oracle Data Block?

How can you find the size of a database?

What is use of Rollback Segments In Database ?

What does LGWR do?

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

Why query fails sometimes ?

For more Oracle Architecture Interview Questions Click Here