SQL Performance (MOSC)

MOSC Banner

SQL TUNING ADVISER

edited Aug 27, 2013 10:14PM in SQL Performance (MOSC) 10 commentsAnswered
 Hello Community!
Hope all are fine. I want to see sql tuning adviser report of the SYS_AUTO_SQL_TUNING_TASK runs every night as scheduled by default. I use the following query to retrieve the results:

set long 100000
set longchunksize 1000
set pagesize 50000
set linesize 100
select dbms_sqltune.report_tuning_task('SYS_AUTO_SQL_TUNING_TASK') as recommendations from dual;

it displays the SQLs with findings order by  Maximum (profile/index) benefit, object ID. the problem I have is I can see in the Detail Section only two or three SQLs.  I have uploaded a reference file. Please Help me

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center