Database Tuning (MOSC)

MOSC Banner

Where to obtain the information about the relationship between a SQL Access Advisor task and sql tun

edited Jul 22, 2014 5:00AM in Database Tuning (MOSC) 3 commentsAnswered

--create a task

declare

task_id pls_integer;

task_name varchar2(10):='chhsaa1';

begin

DBMS_ADVISOR.create_task(advisor_name=>'SQL Access Advisor',task_id=>task_id,task_name=>task_name,task_desc=>'chhsaa1',is_template=>'FALSE');

end;

/

--link the task to a sql tuing sets

begin

DBMS_ADVISOR.ADD_STS_REF(task_name=>'chhsaa1',sts_owner=>'SYS',workload_name=>'chhsts1');

end;

/

Now I need to query the relationship between the task and the STS, which views to query?

Tagged:

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