Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Where is the session timeout value for the duration of running an sql query/procedure

Bob AlstonSep 7 2022

I am using a web service developed by a government entity. Some of my requests which has
been confirmed to be valid requests seemed to be automatically canceled after 10 minutes. When using Soap Sonar personal 9 I receive a response back at 600.8 seconds. I get this response.
image.pngFrom research I understand this is most likely by a processing timeout setting for the query request. What I need help on is exactly where is this setting established - in the application program? In a database setting or procedure? Somewhere else?
So far the entity providing the web service has been unable to locate the setting.

one web source stated the following:
"This error may be due to an internal Sql*Net parameter which times out
the connection. This is called sqlnet.expired.time which logs out users after a set time. Contact your DBA to reset this parameter and retry."
https://www.ibm.com/support/pages/error-ora-01013-user-requested-cancel-current-operation
But if this is the setting in play I don't know how to tell the provider where to look for this.
Thank you.
Bob

Comments

Processing

Post Details

Added on Sep 7 2022
1 comment
1,154 views