12c: Exporting Database Views as Tables
Starting Oracle Database 12c, you can export view to be imported as a table. There is no need to individually export each table, Data Pump will dump a table with…
12c: Sqlplus Displays Last Login Time For Non – Sys Users
12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it…
11gR2:Enable and Disable Oracle Feature with Chopt
Oracle has introduced a utility called Chopt in 11gR2 to enable/disable few database features after database installation. To perform this, you need to shut down database and run the utilty…
11gR2 – SysAsm vs SysDba
SYSASM role was introduced in 11gR1 and was designed to administer ASM instances. In 11gR1 , if you connected with SYSDBA role , you used to get a warning which…
11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
Ever since 11gR2 has been released, it has created a lot of buzz in Oracle Blogosphere with various posts on 11g Release 2 (11gR2 ) New Features primarily ASM New…
11gR2:What if Oracle gives you Kernel parameter fixup script
11gR2 database installation comes up with new feature known as Installation Fixup scripts which aids you during Installation phase. If a pre-requisite check fails, then it provides a click and…