Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
Smallest Free Space % Available (FreeSpace)
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 |