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 constitute an ORACLE Instance?

What is Database Buffers ?

Can a View based on another View in Oracle?

List the Optional Flexible Architecture (OFA) of Oracle database ?

What is the function of Dispatcher (Dnnn)?

What is an oracle database schema?

What is User Process?

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

How will you force database to use particular rollback segment?

How to define Data Block size in Oracle?

What are disadvanteges of having raw devices ?

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

For more Oracle Architecture Interview Questions Click Here