IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home
After running the monitor_stats command, a list of datafiles for each tablespace, their size, and their location is displayed on-screen, followed by statistics for each tablespace.
Example
| Tablespace | File name | Size (Mb) |
|---|---|---|
| MVF | /usr/mvf/data/dbase/data1/mvf01.dbf | 1000 |
| MVFINDX | /usr/mvf/data/dbase/index1/mvfindx01.dbf | 2000 |
| SYSTEM | /usr/mvf/data/dbase/system/system01.dbf | 250 |
| TEMP | /usr/mvf/data/dbase/system/temp01.dbf | 100 |
| TOOLS | /usr/mvf/data/dbase/index2/tools01.dbf | 5 |
| UNDO | /usr/mvf/data/dbase/rbs/undo01.dbf | 200 |
| Tablespace | Free (Mb) | Current Used (Mb) | Avg. Weekly Used (Mb) | Expected Size in 6 Months | Weeks Left |
|---|---|---|---|---|---|
| MVF | 623.6 | 376.4 | 150.7 | 4295.5 | 4.1 |
| TEMP | 100.0 | 0.0 | 0.0 | 0.0 | N/A |
| UNDO | 198.7 | 1.3 | -12.6 | -326.9 | N/A |
| TOOLS | 5.0 | 0.0 | 0.0 | 0.0 | N/A |
| SYSTEM | 133.8 | 116.2 | 46.5 | 1326.4 | 2.9 |
| MVFINDX | 828.7 | 1171.3 | 468.6 | 13354.8 | 1.8 |
See also
Determining available space for the database
Monitoring database statistics
Troubleshooting: monitor_stats fails due to tablespace with insufficient free space
Topic number: 8879 Applies to: IMPAX 6.5.1 Server Knowledge Base |