Category: SQL Developer

December 6, 2015

Installing Java, Oracle 11g R2 Express Edition and SQL Developer on Ubuntu/Mint 64-bit

Installing Java We start with installing Java on the machine. My personal preference is to use Oracle Java JDK. Installing this JDK could be done easily by performing the following statements. sudo add-apt-repository ppa:webupd8team/java...

How to use the SQL Tuning Advisor feature in Oracle SQL Developer

DBA / SQL / SQL Developer

September 5, 2015

How to use the SQL Tuning Advisor feature in Oracle SQL Developer

First execute some codes .. ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS=’DIAGNOSTIC+TUNING’; GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &USER; GRANT advisor to &USER; GRANT administer sql tuning set to &USER; EXEC DBMS_STATS.DELETE_SCHEMA_STATS (‘&USER’); And...