The CHECK_TIME function is used to check the MAX_TIME attribute of the IN_CONTEXT namespace for the specified identifier to determine if MAX_MINUTES has expired when programmatically deciding if the next qualifying operation should be started or not.
This only applies if the MAX_MINUTES session attribute has been set to a value greater than zero using the IN_CONTEXT_SET procedure.
This functionality is currently used by the following stored procedures:
- IN_DB_UTIL.CLEANUP_AUDIT_DATA
- IN_DB_UTIL.REBUILD_INDEXES
- IN_DB_UPGRADE.UPTIME_STEPS
- IN_DB_UPGRADE.SYNC_TABLE_IN_DOC
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | OUTPUT |
| Datatype | VARCHAR2(128) | |
| Default Value: | None | |
| Description | Specifies the identifier for which to check the MAX_TIME session attribute. | |
| Options |
IN_DB_UTIL SYNC UPGRADE |
|
| V_RESULTS | Type: | RETURN |
| Datatype | NUMBER | |
| Default Value: | Null | |
| Description | Specifies if the MAX_TIME session parameter has elapsed. | |
| Options |
0 = MAX_TIME has not yet elapsed or is undefined. 1 = MAX_TIME has elapsed. |
|
Examples
SELECT IN_DB_UTIL.CHECK_TIME(V_IDENTIFIER) FROM DUAL;
SELECT IN_DB_UTIL.CHECK_TIME('IN_DB_UTIL') AS CHECK_TIME FROM DUAL;
SELECT IN_DB_UTIL.CHECK_TIME('SYNC') AS CHECK_TIME FROM DUAL;
SELECT IN_DB_UTIL.CHECK_TIME('UPGRADE') AS CHECK_TIME FROM DUAL;