oracle 12c

The Ask The Advanced Analytics is eanbled on the oracle database 12c as shown below. SQL> select * from v$option where PARAMETER like '%Advanced Analytics%'; PARAMETER VALUE CON_ID ---------------------------------------- -------------------- ---------- Advanced Analytics TRUE 0 User wants to disable this option from database. The Solution In Oracle 12c, Oracle Advanced Analytics is a combination of … [Read more...] about How To Disable Advanced Analytics in Oracle Database 12c?

This is a script to get the tablespace utilization in Oracle Database 12c. You can use this script to get the tablespace utilization ALLOCATED(MB), USED(MB) and Used parentage for all containers tablespaces. sqlplus -s / as sysdba set pages 80 set lin 120 set echo off set feed off column PCT format 999.99 column tbspce format A30 col container for a30 select substr(f.tablespace_name,1,30) tbspce, round(f.tsbytes/(1024*1024),0) "ALLOCATED(MB)", … [Read more...] about Script To Get Tablespace Utilization In Oracle Database 12c

Dropping a Partition Dropping a partition will discard the rows stored in that partition as a DDL statement. This cannot be rolled back. It executes quickly and uses few system resources (Undo and Redo). You must be the owner of the table or have the DROP ANY TABLE privilege to drop a partition. You cannot drop a partition of a hash-partitioned table. You cannot drop a partition from a reference-partitioned table. If a drop partition is performed on a parent table, this operation cascades to … [Read more...] about Oracle database 12c : How to Drop Partition(s)

The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Dropping a Partition Dropping a partition will discard the rows stored in that partition as a DDL statement. This cannot be rolled back. It … [Read more...] about How to Drop/Truncate Multiple Partitions in Oracle 12C

The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Splitting Partition into multiple partitions You can split a partition into multiple partitions. In previous releases, you were able to split … [Read more...] about How to Split a Partition Into Multiple Partitions in Oracle 12c

The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Merging multiple partitions In Oracle 11g, you can merge the content of two partitions only in single DDL. However, in Oracle 12c, you can merge … [Read more...] about How to Merge Multiple Partitions in 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