How will you monitor the space allocation ?

By querying DBA_SEGMENT table/view.

Interview Candidate
Sep 6th, 2004
1
1430

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

nitanjandial

Jan 30th, 2007

+This is the view we should use to see the allocation space +Both the views return the same result.=============================================select name,sum(bytes)"allocated space in MB" from dba_data_files/v$datafile==============================================Thanks and RegardsNitan Jandial