SAA is tuning base on the single SQL statement but the SAA consider the overall system. For example, when SAA recommend to create the index on the table. The SAA would also consider the index could cause the impact for other query.
Image from Oracle document.
Use SAA in OEM cloud control
We can even choice the working set. In this demo, I am going to choice the “current and Recent SQL Activity”
Below code is generate by OEM which is used to defined above tasks.
We can also see the recommendation by query DBMS_ADVISOR.GET_TASK_SCRIPT.
set long 100000
set longchunksize 1000
set linesize 100
SELECT DBMS_ADVISOR.GET_TASK_SCRIPT('MY_SQLACCESS_TUNE') AS script