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 |
Extents Left (ExtentsLeft)
The ExtentsLeft parameter reports the number of extents that can be added to the non-excluded object in a non-excluded user schema that has the least number of extents left. This parameter handles rollback segments other than those present in the SYSTEM tablespace. 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.
When this parameter goes into alarm, the annotation reports all non-excluded objects in non-excluded tablespaces that are below the relevant alert level on warning and alarm.
This parameter considers tablespace, user and object exclusion in its calculations for warnings and alarms.
Recommendations
- Enable the automated recovery feature to resize the next extent when the Free-Space-Deficit-FreeSpaceDeficit parameter alarms.
- Enable the Autoextend option on the tablespace
- The ExtentsLeft parameter is not supported in Locally Managed Tablespaces (LMT). If a database contains all LMT tablespaces, this parameter is de-activated. If a database contains only Dictionary Managed Tablespaces (DMT) tablespaces or both DMT and LMT tablespaces, this parameter will be online. However, in the above condition, the KM will only monitor the DMT tablespaces.
- If the query for this parameter gives performance issues, you can skip the execution of this query by setting the value of the following pconfig variable to 1:
- /OracleConfig.InstanceName.ExcludeExtentsLeft"
This will also skip the execution of the query for the ExtentsLeftPct parameter.
BMC PATROL properties
Attribute | Default value |
---|---|
Application class | ORACLE_AVAILABILITY |
Command type | Not applicable |
Platform | All |
Icon style | Graph |
Unit | Number of extents left |
Border range | Undefined |
Alarm1 range | 0-2 alarm |
Alarm2 range | 2-4 warn |
Scheduling(poll time) | Poll time of collector |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | CollAvailability |
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 |