OracleDB12c New Feature: Misc Security Changes

Security in Oracle12c Database is enhanced, in this blog will try to identify few difference you would see compared with 11gR2. SELECT ANY DICTIONARY privilege in 12c excludes access to the following tables with authentication information: DEFAULT_PWD$ ENC$ LINK$ USER$ USER_HISTORY$ XS$VERIFIERS AUDIT_TRAIL initialization parameter is set to DB by DBUA and DBCA utilities when … Read more

OracleDB12c New Feature: Rename and Replace ASM Disk(s) in Diskgroup

As I have not set up 12c GI ASM yet, have not tested this feature… Rename clause is nice to have. Replace clause helps to avoid multiple steps when replacing disk (LUN) with new one [array migration, for example]. Information below is straight copy from Oracle Documentation… rename_disk_clause ALTER DISKGROUP diskgroup_name RENAME { DISK old_disk_name … Read more

OracleDB12c New Feature: Last Login Time of User

The SYS.USER$ table in Oracle Database 12c includes a column to store the last login time of the user. In the previous releases, to be able to know the last login time of the user, we had to enable “AUDIT SESSION” and then query the AUD$ table. As part of the increased security features in … Read more

OracleDB12c New Feature: No Logging Option in Data Pump Import

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

OracleDB12c New Feature: Added Administrative Privileges

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

OracleDB12c New Feature: Adding, Dropping, Truncating Multiple Partitions

Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement. Add multiple partitions example: ALTER TABLE SALESDATA ADD PARTITION S2015Q1 VALUES LESS THAN (TO_DATE(’01-APR-15′,’DD-MON-YY’)), PARTITION S2015Q2 VALUES LESS THAN (TO_DATE(’01-JUL-15′,’DD-MON-YY’)), PARTITION S2015Q3 VALUES LESS THAN (TO_DATE(’01-OCT-15′,’DD-MON-YY’)), PARTITION S2015Q4 … Read more

OracleDB12c New Feature: Merging and Splitting Multiple Partitions

In Oracle11g, you can merge or split two partitions. This feature is enhanced in 12c to merge and split multiple partitions in a single SQL thus reducing the maintenance operations. When merging range partitions, they must be adjacent. Merging Partitions Example: ALTER TABLE SALESDATA MERGE PARTITIONS S2012Q1, S2012Q2, S2012Q3, S2012Q4 INTO S2012; If range partitions … Read more