How to run SQL Tuning Advisor in SQL Developer

How to run SQL Tuning Advisor in SQL Developer   Required grants to run the SQL Advisor Login as SYSDBA and grant the below privileges to the user who is going to run the SQL ADVISOR   [crayon-5c96092c102c5284313827/]   Run SQL Tuning Advisor   Open SQL Developer >> Write the SQL >> Right Click & [...]

By | 2017-05-21T23:55:35+00:00 May 21st, 2017|Categories: Oracle|Tags: , |Comments Off on How to run SQL Tuning Advisor in SQL Developer

How to generate Explain plan in SQL Developer

How to generate Explain plan in SQL Developer Using Explain Plan, we can find the Order of tables executed the given SQL Index is executed or not Join statement & Order Cost & Cardinality   TO Generate Explain Plan   1. Open SQL Developer >> Open a database connection >> Write a SQL query and [...]

By | 2017-06-11T18:11:42+00:00 May 21st, 2017|Categories: Oracle|Tags: , |Comments Off on How to generate Explain plan in SQL Developer

How to compare two oracle database schemas in SQL Developer Database Diff

How to compare two Oracle database schemas in SQL Developer - Database Diff  Oracle SQL Developer provides a feature called Database Diff to compare two different schemas. Using this, we can compare the tables, views, synonyms, triggers between two schemas. You need to establish a database connection before proceeding the comparison. This section, I have [...]

By | 2017-05-21T16:54:34+00:00 May 21st, 2017|Categories: Oracle|Tags: , , |Comments Off on How to compare two oracle database schemas in SQL Developer Database Diff

How to grant select privilege of tables and views to user ; Oracle DB

How to grant select privilege of tables and views to user;  Oracle DB   To grant individual table to user   [crayon-5c96092c1134f086361813/]     Example: grant select on DUAL to HR   To grant all tables to user   [crayon-5c96092c1135d266898700/]     To Grant Individual View to User    [crayon-5c96092c11363056143697/]     To grant all views to [...]

By | 2017-05-03T08:28:30+00:00 May 1st, 2017|Categories: Oracle|Tags: , , |Comments Off on How to grant select privilege of tables and views to user ; Oracle DB
Like us on Facebook.
Connect!