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

How does Space allocation table place within a block ?

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

What are the consideration at tehe migration of Oracle 9i to 10G.

What is an Integrity Constrains in Oracle?

What is a Rollback segment entry ?

What are the components of SGA?

What is function of RECO?

What are the functions of SMON?

What is the OPTIMAL parameter ?

Diference between Oracle 9i and 10G.

Name the ORACLE Background Process?

How to find the SGA Size

For more Oracle Architecture Interview Questions Click Here