Troubleshooting: monitor_stats fails due to tablespace with insufficient free space

Issue

When running the monitor_stats command, it fails with the following error message:

E 2011.02.18 14:50:28.641 (0x7e0) mainFailed to report monitor statistics

Details

The monitor_stats utility can be used to monitor the Oracle Server database. It provides statistics on how much of a tablespace is available, the space used, and how much space on average is used in a week; however, if not enough free space is available in a tablespace, the utility may fail.

Solution

To allocate more disk space for a tablespace

1. Confirm the amount of available space for the database.

2. Resize an existing datafile which keeps the number of Oracle datafiles to a minimum and simplifies their administration.

   or

   Add a new datafile to the tablespace.

3. Run the monitor_stats command again.