SQL Performance (MOSC)

MOSC Banner

Running SQL tuning Advisor via Cloud Control 12.2 vs running it manually

edited Oct 31, 2019 5:01AM in SQL Performance (MOSC) 1 commentAnswered

We are running query optimizer advisor from the different sources and getting different results.

1. Via Cloud control creating/executing  took 12 min and response time get down from 1h to 3 min.

2. Via Toad the same query (with existing profile from 1) took 1.5 hour to create a task, and execution of the task did not improve response time. May be because the profile existed?

3.Via manual DBMS_SQLTUNE session simial to 1.

Is there any difference between these methods with respect to query optimizer advisor?

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