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 an oracle database schema?

What is a Multi-threaded Server Configuration?

How the log writer writes the data into database

What are the functions of SMON?

What is an Oracle Data Segment?

How can we plan storage for very large tables ?

What is the OPTIMAL parameter ?

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

How does Space allocation table place within a block ?

How can you find the size of a database?

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

Can a Tablespace hold objects from different Schemes in Oracle?

For more Oracle Architecture Interview Questions Click Here