How will you monitor the space allocation ?
Answers were Sorted based on User's Feedback
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 |
Answer / karthickumar pillaiyarsamy
select sum(bytes) from dba_data_files
Is This Answer Correct ? | 0 Yes | 0 No |
What Does DBWR do?
What is the function of Redo Log in Oracle?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is the role of PCTFREE parameter is Storage clause ?
How to define Data Block size in Oracle?
What is the function of Dispatcher (Dnnn)?
What is an Oracle Data Dictionary?
What is function of RECO?
How the log writer writes the data into database
What is the functionality of SYSTEM table space ?
What is an oracle database schema?
When Does DBWR write to the database?