Forum Stats

  • 3,757,253 Users
  • 2,251,215 Discussions


Tuning Advisor in Oracle 19c

Satyam Reddy
Satyam Reddy Member Posts: 295 Bronze Badge
edited Aug 12, 2021 5:05PM in General Database Discussions


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 !!

Edited : Ours is a standard edition of Oracle.