Smallest Free Space % Available (FreeSpace)
Warning
This feature is no longer supported by the KM version 9.7.11.03. For more information see, 9.7.11.03: Fix Pack 3 for BMC PATROL for Oracle Database.
The FreeSpace parameter shows the percentage of space available in all non-excluded, dictionary-managed or locally managed, uniform or system allocated, non-autoextensible tablespaces.
For undo tablespaces, this parameter queries the db_undo_extents view in addition to the dba_free_space view to calculate percentage of available space. From the db_undo_extents view, it considers the non-active extents (expired and unexpired) as the available space.
When this parameter goes into an alarm state, the annotation report lists the following information:
Field | Description |
---|---|
Tablespace Name | Name of the tablespace |
Total Space | Total space allocated to the tablespace |
Space Used | Space used in the tablespace |
Space Left | Free space in the tablespace |
Percent Free | Percentage of free space available in the tablespace |
This parameter considers tablespace exclusion in its calculations for warnings and alarms.
If a tablespace is autoextensible, FreeSpace does not go into an alarm state for that tablespace. If all monitored tablespaces are autoextensible, Cannot Auto Extend (CannotExtend) monitors autoextended tablespaces and their segments.
Only permanent tablespaces are monitored by this parameter. To monitor temporary tablespaces, you must use Smallest Free Space Available in Temporary Tablespaces (TempTSLeft) and Smallest Free Space % Available in Temporary Tablespaces (TempTSLeftPct).
This parameter becomes inactive if the tablespace is autoextensible.
Recommendations
- Add a datafile to the tablespace.
- Drop any unwanted objects from the tablespace.
If you have recently added a datafile to your tablespace, the datafile will be monitored after ten polling cycles of CollAvailability.
BMC PATROL properties
Attribute | Default value |
---|---|
Application class | ORACLE_AVAILABILITY |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Percentage of available space |
Border range | Undefined |
Alarm1 range | 0-5 alarm |
Alarm2 range | 5-10 warn |
Scheduling(poll time) | Poll time of collector |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | CollAvailability |
Variable | Blocks_free = select sum(length) from sys.fet$ where ts# = :ts;Total_blocks = select sum(blocks) from sys.file$ where ts# = :ts; |
BMC ProactiveNet Performance Management properties
Property | Default value |
---|---|
Monitor type | Oracle Database Availability |
Key Performance Indicator | Yes |
Monitor for abnormalities | Yes |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | Yes |
Comments