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.
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
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’;
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?
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.
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
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’;
Run the sqltrpt.sql instead of creating task would be easy..nice lecture though
Hi sir
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?