oracle 12c

The distinguishing feature of synchronous refresh is that changes to a table and its MVs are loaded and refreshed together, hence the name synchronous refresh. In a typical data warehouse, data preparation consists of extracting the data from one or more sources, cleansing, and formatting it for consistency,and transforming into the data warehouse schema. The data preparation area is called the staging area and the base tables in a data warehouse are loaded from the tables in the staging … [Read more...] about How to do a Synchronous Refresh with Staging Logs in Oracle 12c

The core architecture of the scheduler remains the same in 12c with some enhancements and few exceptions in case of the multitenant environment. Enhancements/Modifications Dictionary Views: The below additional columns are added to the *__SCHEDULER_JOB_RUN_DETAILS. Out of these, ERRORS and OUTPUT will be very helpful. ERRORS column shows the error messages related to the job run and the OUTPUT column shows the log of activity during the job run. Earlier, we used to use … [Read more...] about Oracle Scheduler 12c New Features and Enhancements

The post provides steps to create scheduler jobs in a multitenant database. It covers only DBMS_SCHEDULER jobs. The jobs created using DBMS_JOB jobs have not been covered here since DBMS_JOB has been retained in later versions of Oracle mainly for backward compatibility. It is highly recommended to migrate from DBMS_JOB to DBMS_SCHEDULER jobs. Scheduler job in a CDB Verify that this is a container DB and check the container IDs. SQL> select cdb from v$database; CDB --- YES SQL> … [Read more...] about Oracle Database 12c : Creating a Scheduler Job in a Multitenant Database

Till 12cR1 the Undo tablespace used to be shared or global across all the PDBs in a container. From 12cR2 onwards, the local Undo is introduced. When local undo is enabled, each container has its own undo tablespace for every instance in which it is open. When local undo is disabled, there is one undo tablespace for the entire CDB. The Undo mode, whether it’s local or shared, is the property of the entire CDB. Either all the PDBs are local undo mode or there’s shared undo for the entire CDB. … [Read more...] about Undo Modes in 12.2 Multitenant Databases – Local and Shared Modes