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 IndicatorYes
Monitor for abnormalities
Yes
Graph by default
No
AvailabilityNo
Response time
No
Normal distribution
Yes
StatisticalYes
Was this page helpful? Yes No Submitting... Thank you

Comments