Enable SQL Tuning Advisor in Oracle

ALTER SYSTEM SET control_management_pack_access='DIAGNOSTIC+TUNING' SCOPE = BOTH;
GRANT ADVISOR TO testing;
GRANT ADMINISTER SQL TUNING SET TO testing;

https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/index.html