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 | |
Enqueue Resources in Use (LocksUsed)
The LocksUsed parameter reports the percentage of used enqueue resources.
Recommendations
If there is a contention on enqueue resources, increase the init.ora enqueue_resources parameter. When setting the enqueue_resources parameter, allow one process per resource, regardless of the number of sessions or cursors using the resource, not one per lock.
Use the following table to select the appropriate value for enqueue_resources:
If init.ora processes value is... | Set enqueue_resources default value to... |
|---|---|
3 or less | 20 |
between 4 and 10 | [(processes - 3) * 5] 20 |
greater than 10 | [(processes - 10) * 2] 55 |
Do not assign enqueue_resources a value greater than the sum of the init.ora parameters (dml_locks ddl_locks).
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | ORACLE_CAPACITY |
Command type | not applicable |
Platform | all |
Icon style | Gauge |
Unit | percentage of used enqueue resources |
Border range | undefined |
Alarm1 range | undefined |
Alarm2 range | undefined |
Scheduling(poll time) | poll time of collector |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | CollCapacity |
BMC ProactiveNet Performance Management properties
Attribute | Default value |
|---|---|
Monitor type | Oracle Database Capacity |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | Yes |