|
||||
|
Earlier to 12c, when an partition is truncated with update global index clause the operation will take longer to complete since it has to perform the operation on index also to remove corresponding keys in index partition/index and then rebuild entire partition. But that is history, Asynchronous global index maintainence is the feature to clear […] From 12c, interval partitions has been enhanced to use reference partitioning, With this you can create a parent/child table with references in them using interval partitioning. The following is the test case. Create table EMPLOYEE ( EMPLOYEE_ID number primary key, EMPLOYEE_NAME varchar(25), JOINING_DATE date) PARTITION BY RANGE (JOINING_DATE) INTERVAL (NUMTOYMINTERVAL(1,’YEAR’)) ( PARTITION P_2013_06 VALUES LESS […] From 12c, you can truncate partitions from a referenced partition with cascade option. The following is the test case. Create table EMPLOYEE ( EMPLOYEE_ID number primary key, EMPLOYEE_NAME varchar(25), JOINING_DATE date) PARTITION BY RANGE (JOINING_DATE)( PARTITION P_2013_06 VALUES LESS THAN (to_date(’30-06-2013′,’dd-mm-yyyy’)) NOCOMPRESS, PARTITION P_2013_07 VALUES LESS THAN (to_date(’31-07-2013′,’dd-mm-yyyy’)) NOCOMPRESS, PARTITION P_2013_08 VALUES LESS THAN (to_date(’31-08-2013′,’dd-mm-yyyy’)) […] In 12c, Oracle introduced package to manage the global indexes orphan entry clean up and clearing up the online partition movement stuff. Here it is PROCEDURE CLEANUP_GIDX- To clean up the global indexes , this runs daily at 2.00AM via scheduler job automatically PROCEDURE CLEANUP_GIDX_INTERNAL – To clean up the internal tables PROCEDURE CLEANUP_ONLINE_OP […] 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 […] Got this architecture diagram from the internet for 12c database
Source:- Some explanation according to my understanding:- 1) Oracle SGA is shared between multiple databases called Pluggable databases (PDB) 2) A root database called container database which holds all the Oracle dictionary globally (CDB) shareable across PDB’s 3) Listener registers both CDB instance […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!