IMPAX 6.5.1 Server Knowledge Base home > Oracle Server home
Use the monitor_stats utility to monitor the database. You can check how much space is available for tablespaces, the space used, and how much space on average is used in a week.
To monitor database statistics
At a command prompt on the Oracle Database Server, type
monitor_stats (Solaris) or bash monitor_stats (Windows)
A list of datafiles for each tablespace, their size, and location is displayed on-screen, followed by statistics for each tablespace. An example is provided in Example database statistics.
The statistics for each tablespace are:
| Column | Description |
|---|---|
| Free (Mb) | The available space (in megabytes) for the tablespace |
| Current Used (Mb) | How much space (in megabytes) is already used for the tablespace |
| Avg. Weekly Used (Mb) | How much space (in megabytes) in the tablespace is used on average in a week |
| Expected Size in 6 Months | Estimates the size of the tablespace in six months |
| Weeks Left | How many weeks are left until the tablespace is full |
See also
Adding a new datafile to the tablespace
Collecting database statistics
Tools for monitoring Oracle Data Guard
Troubleshooting: monitor_stats fails due to tablespace with insufficient free space
Topic number: 8880 Applies to: IMPAX 6.5.1 Server Knowledge Base |