| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Provides a method of changing some Hang Manager configuration parameters. |
| AUTHID |
DEFINER |
| Constants |
| Name |
Data Type |
Value |
| Parameter Names |
| RESOLUTION_SCOPE |
VARCHAR2(40) |
'resolution scope' |
| SENSITIVITY |
VARCHAR2(40) |
'sensitivty' |
| BASE_FILE_SIZE_LIMIT |
VARCHAR2(40) |
'base file size limit' |
| BASE_FILE_SET_COUNT |
VARCHAR2(40) |
'base file set count' |
| LWS_FILE_SIZE_LIMIT |
VARCHAR2(40) |
'long waiting session file size limit' |
| LWS_FILE_SET_COUNT |
VARCHAR2(40) |
'long waiting session file set count' |
| Resolution Scope Values |
| RESOLUTION_SCOPE_OFF |
VARCHAR2(20) |
'OFF' |
| RESOLUTION_SCOPE_PROCESS |
VARCHAR2(20) |
'PROCESS' |
| RESOLUTION_SCOPE_INSTANCE |
VARCHAR2(20) |
'INSTANCE' |
| RESOLUTION_SCOPE_NODE |
VARCHAR2(20) |
'NODE' |
|
Sensitivity Values |
| SENSITIVITY_NORMAL |
VARCHAR2(20) |
'NORMAL |
| SENSITIVITY_HIGH |
VARCHAR2(20) |
'HIGH' |
|
| Dependencies |
| DBMS_BLOCKER_RESOLVER |
DBMS_HANG_MANAGER_LIB |
|
| Documented |
Yes: Packages and Types Reference |
| Exceptions |
| Error Code |
Reason |
| ORA-32706 |
Invalid User Input |
| ORA-32707 |
Error generated while trying to set the parameter |
| ORA-32708 |
Operation is not supported on this instance type |
|
| First Available |
12.2 |
| Pragmas |
SUPPLEMENTAL_LOG_DATA(default, AUTO_WITH_COMMIT); |
| Security Model |
Owned by SYS with EXECUTE granted to the DBA role |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmshmgr.sql |
| |
| SET |
| Sets the specified Hang Manager parameter to the specified value. |
dbms_hang_manager.set(
pname IN VARCHAR2,
pvalue IN VARCHAR2);
-- Additional parameters not defined as constants (above) specify BASE_FILE_SET_COUNT (default 5), BASE_FILE_SIZE_LIMIT (default 100MB), LWS_FILE_SET_COUNT (default 5), LWS_FILE_SIZE_LIMIT (default 100MB), RESOLUTION_SCOPE, and SENSITIVITY. |
exec dbms_hang_manager.set(dbms_hang_manager.base_file_size_limit, '250');
PL/SQL procedure successfuly commpleted. |