|
||||
|
Before to 12c, if you want to maintain partitions you will need to execute that many alter statements partition commands that many times. For example to add p7,p8 partitions, you have to use SQL> alter table test_tbl add partition p7 values less than (7) SQL> alter table test_tbl add partition p8 values less than […] Before to 12c, it is not possible to create a index for certain partitions or for the partitions you want. From 12c onwards, you can create the indexes (global or local) for specific partitions (not to all partitions) or for specific sub partitions (not to all sub partitions). This means indexes will be created […] From 12c onwards, partitions movement has been extended with "online clause", along with this global index are maintained during partition maintenance , hence manual rebuild of index is not required any more. Before proceeding with the test, here are some restriction as listed in documentation, ONLINE clause can’t be specified ?for tables owned by […] 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 […] The following are the parameters are introduced newly in 12c. (Note I have compared them with 11.2.0.1 Database) Excluded _Parameters
select KSPPINM, KSPPDESC from x$ksppi where con_id=1 minus select KSPPINM, KSPPDESC from t2@Geek DBA11g order by 1,2 awr_snapshot_time_offset Setting for AWR Snapshot Time Offset cell_offloadgroup_name Set the offload group name clonedb clone database connection_brokers […] 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 […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!