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

Diference between Oracle 9i and 10G.

What is SGA?

How will you monitor the space allocation ?

What do Redo Log Buffers contain?

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

What is hit ratio ?

What is the functionality of SYSTEM table space ?

What is dictionary cache ?

How to find the SGA Size

What is an Oracle Rollback Segment?

What is a Multi-threaded Server Configuration?

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

For more Oracle Architecture Interview Questions Click Here