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

List the factors that can affect the accuracy of the estimations ?

What is a Control file ?

What is a Multi-threaded Server Configuration?

What Does DBWR do?

How many Dispatcher Processes are created?

How the log writer writes the data into database

How to find the current session sid

How does Space allocation table place within a block ?

What is the function of Dispatcher (Dnnn)?

What is Database Buffers ?

How can you find the size of a database?

How to find the SGA Size

For more Oracle Architecture Interview Questions Click Here