Oracle Analytics Cloud and Server Idea Lab

Products Banner

Auto Terminate long running Query

Under Oracle Review

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):


Description (Required):

The Doc ID 2783635.1 mentions how to manually kill long running sessions.

But there is there no automated process for handling long running sessions in OAC. For example, to auto kill sessions which are running for 4 hours or 6 hours. 

Use Case and Business Need (Required):

There are certain reports which are running for several hours and causing adhoc over head on both the DB and OAC systems. Currently, administrators are either killing the reports on the DB (backend) or through OAC - Manage Sessions link.

If there could be a setting (maybe some timeout parameter introduced) which auto terminates reports/queries running for more than certain time, it would reduce the manual intervention.

Enhancement Request / Service Request:


4 votes

Under Oracle Review · Last Updated


  • Hi, This would be great feature to have this enabled in OAC when we have user sessions running for a long time to auto kill and make the application performance stable.

  • I'm not sure I understand this one. OAC has a limit of 60 minutes for queries and 10 minutes for RDG queries. User session timeout is usually set based on each organization's security policies, and there is also an OAC user inactivity timeout, which customers can enable. What is the scenario in which you have sessions running for long hours? Are the database queries not being canceled?

  • Hi Gabby, Currently we see some performance issues within OAC and noticed that some of the user sessions were running more than 30 minutes and getting cancelled after an hour or equal to 60 mins.Since we cant have user sessions for more than 10 mins it will be good to have option or script to disable OAC sessions running >10mins.