Mastering the Oracle Stack, One Post at a Time.
Oracle Database, the related services (cloud) and various options in the database.
Datapump Import impdp in 12c includes a new parameter to disable logging during data import. This option could improve performance of import tremendously during large data loads. The TRANSFORM=DISABLE_ARCHIVE_LOGGING is used to disable logging. The value can be Y or N. Y to disable logging and N to enable logging. The second attribute specifies whether … Read more
Oracle11g Grid Infrastructure introduced SYSASM administrative privilege, in 12c we have 3 more administrative privileges… SYSBACKUP, SYSDG, SYSKM. SYSDBA, SYSOPER and SYSASM privileges and behavior are similar to 11gR2 in 12c database as well. SYSBACKUP administrative privilege has ability to perform RMAN backup and recovery operations, database startup and shutdown. This administrative user connects to … Read more