|
||||
|
Prior to 12c, if the developer wants to create a sequential ID number generator , he/she has to use a sequence and then a trigger or reference that seq value in the insert statement. From 12c Onwards, this has been enhanced by providing the sequence.nextval in the table definition itself. Further it even enhanced that […] New Background Processes that has been introduced from 12c, compared with 11.2.0.2 Database.
12 C Process Name AQPC AQ Process Coordinator ARSn ASM Recovery Slave Process BWnn Database Writer Process FENC Fence Monitor Process IPC0 IPC Service Background Process LDDn Global Enqueue Service Daemon Helper Slave LGnn Log Writer Worker LREG Listener Registration Process […] Here are the some of enhancements for Import (IMPDP) Disabling Logging for Oracle Data Pump Import You can now use the DISABLE_ARCHIVE_LOGGING Paramaeter to disable logging for table, index or both during import. Logging is not completely disable but only a small amount is generated. Also don`t forget that there is a database parameter […] Here is the list of enhancements for export datapump.
expdp Specifying the Encryption Password You can now specify silently a password during runtime. When you import a encrypted Dumpfile you can pass the Password for that file from the STDIN. The password will not visible by commands like ps or will not […] From 12c Onwards, Oracle has made some important changes to SQLloader and enhanced a lot, one of the feature was express loading with minimal configuration. You will just need to create a data file with same name as Table name and thats it no control file or other parameters required. It just default […] From 12c Onwards, Oracle statistics gathering has been improvised and after bulk load operations the statistics will be gather automatically. Earlier, Create as select , or Insert as select operations required manual statistics gathering, where in this has been removed now. The following bulk operations is supportive for automatic statistics gather on fly. CREATE […] As discussed, earlier, Another important nice feature in RMAN from 12c is using network based recovery or incremental backup strategy from the servics. This eliminates taking incremental backups or copy those backup to standby and saves lot of time. Lets check, On Primary, check the latest log Check on Primary SQL> archive log […] Step by Step standby creation using RMAN duplicate database This post is about to create a standby database in container enabled database (Just want to check any changes required from previous versions steps) All steps are similar like previous versions except we have to create directory structures for PDB databases otherwise RMAN script will fail […] From 12c onwards, we can create a mixed indexes (bitmap and btree both) on same columns which is very useful in DW environments. Before to 12c you will receive the such column is already indexed error or index already exists if you want to create the same. I have a copy of dba_objects as […] 12c Introduced the datafiles movement online, Earlier to 12c we have to a) offline the datafile b) Move the datafile to new location using os command c) Rename the datafile for data dictionary update d) Online the datafile From 12c, its just need a command "alter database move datafile" Lets see how it works […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!