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 are the functions of SMON?

What are the two types of Server Configurations?

What are Oracle Schema Objects?

How will you estimate the space required by a non-clustered tables?

What is an Oracle Data Block?

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

What is Database Buffers ?

How to find the current session sid

How will you monitor the space allocation ?

How will you monitor rollback segment status ?

How many Dispatcher Processes are created?

How to implement the multiple control files for an existing database ?

For more Oracle Architecture Interview Questions Click Here