Dbms_advisor

Hi Folks,

couple of questions:

1. DBMS_ADVISOR works on current workload unless I say DBMS_ADVISOR.quick_tune ....... what is the definition of current workload? Which all queries does it consider and from where to advise me?

2. In DBMS_ADVISOR.quick_tune - is there nay limit of sql text?


Regards
Sumit

1- Queries currently sitting on SQL cache.
2- Since you have to put your sql in a varchar2() ... 4000 bytes is the limit.