SQL Performance (MOSC)

MOSC Banner

Specific SQL ID causing Auto SQL Tuning Task to Fail

edited May 9, 2019 8:58AM in SQL Performance (MOSC) 5 commentsAnswered ✓
We've been seeing these hang errors on one of our databases several times per week: Process 0xxxx appears to be hung in Auto SQL Tuning Task. Using the queries mentioned here: Bug 9874145, I found the specific sql id that is causing the time out. It's a query run from a wf that runs daily, so there is no chance of the query getting aged out. This document suggests either disabling auto tuning (no!) or increasing the time limit interval: 1344499.1.

I was wondering though, if since we know the exact sql id of the query causing the issue, is there any way to get the auto tuning task to ignore a particular sql id instead of having to change a parameter value?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center