SQL Performance (MOSC)

MOSC Banner

Inline Hint Clarification

in SQL Performance (MOSC) 4 commentsAnswered

Hi,

Oracle Database Version - 12.2.0.1.220118

OS - Oracle Linux Server release 6.10

Issue - With Subquery is running long time.

I need some clarification regarding INLINE hint injections on With subquery sql . Can it be controlled using baseline or patch? because I tried it but not working. Followed below to make it effect but none helped.

1 . Created baseline but not working.

2.. created SQL patch but not working.

3.. Ran with outline hints but no luck.

4.. Tried with session parameter _with_subquery=inline but no luck

only working case is when we inject hint in specific with subquery inside sql statement for which code change is mandatory which is not possible now.

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