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 the significance of having storage clause ?

What is Cursor?

What is a Rollback segment entry ?

What is the functionality of SYSTEM table space ?

When Does DBWR write to the database?

What are the two types of Server Configurations?

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

What constitute an ORACLE Instance?

What is an Oracle Data Segment?

What is User Process?

What is the function of Lock (LCKn) Process?

What is Shared SQL Area?

For more Oracle Architecture Interview Questions Click Here