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 a Control file ?

How does Space allocation table place within a block ?

What is an Oracle Data Block?

What is Dedicated Server Configuration?

What is an oracle database schema?

What is an Oracle Rollback Segment?

What is function of RECO?

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

How will you swap objects into a different table space for an existing database?

Teradata: How can we know the indexed column in a table?

What are functions of PMON?

Name the ORACLE Background Process?

For more Oracle Architecture Interview Questions Click Here