Smallest Free Space % Available in Temporary Tablespaces (TempTSLeftPct)
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.
This parameter displays the percentage of space left in the temporary tablespaces (both DMTS and LMTS). The calculations include both extensible and non-extensible datafiles and temp files. TempTSLeftPct will go into warning when the percentage of space left in the TEMPORARY tablespace has reached 10%, and will go into alarm when the percentage of space left reaches 5%.
This parameter considers tablespace, user and object exclusion in its calculations for warnings and alarms.
This parameter is supported if the instance uses ASM storage.
Situation | Monitoring status |
|---|---|
No temporary tablespaces | Parameter is inactive |
Temporary tablespaces exist, but have been excluded from monitoring | Parameter is offline (grayed out) |
OS KM is not loaded | Calculations are based on the data in the Oracle tables rather than from the operating system |
Instance with temporary tablespaces is remote | Calculations are based on the data in the Oracle tables rather than from the operating system |
Tablespaces exist, are included in monitoring, are local instances, and OS KM is loaded | Parameter is active, and the calculation are based on data collected from OS KM |
OS KM is loaded but FILESYSTEM Parameters are offline | Parameter will be in OFFLINE state. |
Recommendations
If this parameter goes into alarm, consider adding another datafile.
BMC PATROL properties
Attribute | Default value |
|---|---|
Application class | ORACLE_AVAILABILITYY |
Command type | N/A |
Platform | ALL_COMPUTERS |
Icon style | Graph |
Unit | Percentage |
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 | CollTempTS |
BMC ProactiveNet Performance Management properties
Property | Default value |
|---|---|
| Monitor type | Oracle Database Availability |
| Key Performance Indicator | No |
| Monitor for abnormalities | Yes |
| Graph by default | No |
| Availability | No |
| Response time | No |
| Normal distribution | Yes |
| Statistical | Yes |
Comments