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-5997284238480427857142/]   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: , |0 Comments

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: , |0 Comments

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: , , |0 Comments

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-5997284239090177185734/]     Example: grant select on DUAL to HR   To grant all tables to user   [crayon-599728423909c216665664/]     To Grant Individual View to User    [crayon-59972842390a3292345099/]     To grant all views to [...]

By | 2017-05-03T08:28:30+00:00 May 1st, 2017|Categories: Oracle|Tags: , , |0 Comments

How to completely uninstall Oracle Database 12C

How to completely Uninstall Oracle Database 12C  Oracle 12C database provides a built-in utility file deinstall.bat ( sh ) that is used to uninstall Oracle Database 12 completely from the system. Below are some useful points before continuing the uninstallation   1. The deinstaller will take care of stopping all the services run by Oracle [...]

By | 2017-01-29T01:03:47+00:00 January 28th, 2017|Categories: Oracle|Tags: , , |0 Comments

How to enable Transparent Data Encryption (TDE) in Oracle database

How to enable Transparent Data Encryption (TDE) in Oracle database TDE is an encryption mechanism present in Oracle database used to encrypt the data stored in a table column or tablespace. It protects the data stored on database files (DBF) by doing an encryption in case the file is stolen or hacked. TDE supports any of [...]

By | 2017-01-22T01:11:56+00:00 January 21st, 2017|Categories: Oracle|Tags: , , , |0 Comments

Uninstall Oracle XE 11G database on Windows 10

Uninstall Oracle XE 11G database on Windows. In this section, I have explained how to Uninstall Oracle Xe 11G database on Windows machine.      Pre-Requisite: 1. Close any existing database connection if opened already 2. Stop the Oracle XE database services in Windows Services if it is running 3. Close all the folders   [...]

Like us on Facebook.
Connect!