Defining CONNECT_TIME for a profile, according to oracle documentation
CONNECT_TIME
Specify the total elapsed time for the session, expressed in minutes.
I assume that they mean by connection time - this is the time taken to complete the procedure as a whole.
Is there a way to limit the connection time for executing a request in a procedure? For example, if a procedure has 3 execution requests and any request exceeds the specified time, then the session must be interrupted or killed.
source share