Smallest Free Space % Available in Temporary Tablespaces (TempTSLeftPct)
Error rendering macro 'Include+'
The 'Include+' macro can only be used in spaces managed by Scroll Versions / Scroll Translations.
All 'Include+' and 'Excerpt Include+' macros must be converted to normal 'Include Page' and 'Excerpt Include' macros in such spaces.
Please use the macro conversion tool to detect and fix similar issues in this space or ask a space administrator to do so.
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
Log in or register to comment.