Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Performance Hub(Tuning Advisor) in Oracle 19c

Satyam ReddyAug 11 2021

Team,
I'm not sure if this is the correct group to ask this question.
In case if this is not the right group , please help me in approaching the correct group.
My query is :
In Oracle 19c Enterprise Manager Database Express, do we have any option of tuning advisor in order to tune any Sql statement which is consuming lot of resources ,like as we have the "schedule tuning advisor" in Oracle 11g under Performance Tab--Top Activity--Select Query (and we see it at the top right corner).
if we have any such option, can someone please guide us to approach such an option of tuning advisor for query tuning.
Please do let us know in case we need to have any pre-requisites(Extra licensing .if so which license) for the above task.
Thank You !!

Comments

Processing

Post Details

Added on Aug 11 2021
0 comments
79 views