Oracle SQL tuning advisor

Подписаться 37 тыс.

Просмотров 19 тыс.

50% 1

The #SQL #Tuning #Advisor analyzes high-volume SQL statements and offers tuning recommendations. It takes one or more SQL statements as an #input and invokes the Automatic Tuning #Optimizer to perform SQL tuning on the statements. It can run against any given SQL statement. The SQL Tuning Advisor provides advice in the form of precise SQL actions for tuning the SQL statements along with their expected performance benefits.
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve performance. It might give suggestion to create few indexes or accepting a SQL profile.
00:00 Automatic SQL Tuning in Oracle
04:26 Lab practice
05:21 Create tuning task
09:12 Execute tuning task
09:47 Status of tuning task
10:29 Display recommendation
17:28 Why some recommendations are wrong. Example?
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

Наука

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 6

@ks2580 3 года назад

thats is why it also recommend to use segment advisor against the sql set of which this sql belongs (for any index recommendation in STA), this way impact of index is ascertained against sql set and we can analyze the index advice from STA.

@raniachettab6146 4 года назад

ERROR at line 1: ORA-13717: Tuning Package License is needed for using this feature. ORA-06512: at "SYS.PRVT_SMGUTIL", line 52 ORA-06512: at "SYS.PRVT_SMGUTIL", line 37 ORA-06512: at "SYS.DBMS_MANAGEMENT_PACKS", line 26 ORA-06512: at "SYS.DBMS_SQLTUNE", line 651 ORA-06512: at line 4

@dbagenesis 4 года назад

you need additional tuning pack license. Check with Oracle support if you already have license then you can activate it on your DB via below commands: SQL> show parameter control_management_pack SQL> ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS=‘DIAGNOSTIC+TUNING’;

@how_and_why 3 года назад

Run the sqltrpt.sql instead of creating task would be easy..nice lecture though

@syedismail1981 2 года назад

Hi sir

@syedismail1981 2 года назад

I have a one doubt in query when I have created the index on employees salary table , then I have write the query ,select empsal from rajind where sal='6000'; in this situation the query will run the full table scan or the query will go to block where the 6000 is there?