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 to find the current session sid

• What is oracle Architecture?

Diference between Oracle 9i and 10G.

What are the two types of Server Configurations?

What are the uses of Oracle Rollback Segment?

What is meant by redo log buffer ?

What is dictionary cache ?

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

Name the ORACLE Background Process?

What is an Oracle Data Dictionary?

What is use of Rollback Segments In Database ?

1.Explain the three levels with the help og a diagram.

For more Oracle Architecture Interview Questions Click Here