Reset the Resource Timeout Limit
Use this API to reset the current session timeout limit for all user database accounts to the default limit of 24 hours.
Name
CDR_PUB_ResourceLimits.resetResourceLimitToDefault
Signature
PROCEDURE resetResourceLimitToDefault ( p_api_version IN VARCHAR2 , p_init_msg_list IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE , p_commit IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE , p_validation_level IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL , x_return_status OUT NOCOPY VARCHAR2 , x_msg_count OUT NOCOPY NUMBER , x_msg_data OUT NOCOPY VARCHAR2 , p_name IN cdr_db_resource_limits.name%TYPE , p_all IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- P_NAME (Mandatory) Enter the current value set for the database profile
name.
- CONNECT_TIME
- P_ALL (Mandatory) Enter T (to reset all profile limits to the default and ignore the P_NAME setting) or F (to reset the limit to default for the specified name).
Parent topic: Create and Modify Security Policies