| |
 |
|
Oracle Tips by Burleson Consulting |
Monitoring Tablespace
Autoextend Settings
In addition to space usage and fragmentation
monitoring, if you use the autoextend feature, you need to monitor
database autoextend status and data file locations. Source 11.16
shows the SQL to create a view that monitors autoextend data for
pre-Oracle8. In pre-Oracle8 versions, the only way to get this
information was to query the SYS table FILEXT$, which,
unfortunately, looks like this:
See Code Depot
Using this
view, it is then easy to create a simple SELECT that gets autoextend
and data file location information from a single view, along with
all of the pertinent sizing information. The Oracle Administrator
Storage Manager does show this information under the data files
section. In Oracle8i, the view DBA_DATA_FILES contains the columns
AUTOEXTENSIBLE (YES or NO), MAXBYTES, MAXBLOCKS, and INCREMENT_BY,
which allow for ease of report generation and monitoring of the
autoextension capabilities of all data files.
www.dba-oracle.com/oracle_scripts.htm |
