One of the new Data Guard Broker features introduced in Oracle 12c Release 2 was the ability to set multiple Fast Start Failover (FSFO) targets with the broker determining which was the ideal Data Guard standby database to perform a failover operation to. This was configured via the property FastStartFailoverTarget. In this example we have […]
A number of new features were added in Oracle 12c Release 2 and Oracle 18c related to SQL*Plus. Let us have a quick look at some of these new features and how they can be used. Oracle 18c SET FEEDBACK ON SQL_ID: Display the sql_id for the currently executed SQL statement SET ROWLIMIT n: […]
New in Oracle 12c Release 2 is the ability for scripts to be executed through the Data Guard broker DGMGRL command-line interface very similar to like say in SQL*Plus. DGMGRL commands, SQL commands using the DGMGRL SQL command, and OS commands using the new HOST (or !) capability can be bundled into a script file […]
In Oracle 12c Release 2, tablespaces can now be encrypted while they are online and in read-write mode. In earlier releases, the tablespace had to be taken offline first or the database had to be in the mount state and not open. In addition, now in 12.2 the SYSTEM, SYSAUX and UNDO tablespaces can also […]
This note describes the new features related to the Oracle Database Multitenant option which have been introduced in Oracle 12c Release 2 (12.2.0.1). The hands-on exercises included in the note demonstrates the use of the following new multitenancy features: Hot Cloning Refreshable Pluggable Databases Support for pluggable databases with multiple character sets Proxy Pluggable Databases […]
In the earlier 12.1.0.2 Oracle database version, we could limit the amount of CPU utilization as well as Parallel Server allocation at the PDB level via Resource Plans. Now in 12c Release 2, we can not only regulate CPU and Parallelism at the Pluggable database level, but in addition we can also restrict the amount […]
One of the new multitenancy related features in Oracle 12c Release 2 is Application Containers. In 12c Release 1, we could have a Container database (CDB) host a number of optional pluggable databases or PDBs. Now in 12.2.0.1, the multitenancy feature has been enhanced further and we can now have not only CDBs and PDBs […]
One of the real nice new features in Oracle 12c Release 2 (12.2.0.1) is the ability to create an Oracle Data Guard Standby Database using DBCA (Database Configuration Assistant). This really does simplify the process of creating a standby database as well and automates a number of steps in the creation process which were earlier […]
Online Move Partition In Oracle 12c we can now move as well as compress partitions online while DML transactions on the partitioned table are in progress. In earlier versions we would get an error like the one shown below if we attempted to move a partition while a DML statement on the partitioned table was […]
If we are dealing with large amounts of data and have to use queries to find count of distinct values of some particular column or group of columns, the new 12.1.0.2 feature APPROX_COUNT_DISTINCT function can be significantly faster than using the traditional COUNT (DISTINCT expr) function with marginal differences in the exact result. The examples […]
In Oracle 12c when we create a table we can populate a column automatically via a system generated sequence by using the GENERATED AS IDENTITY clause in the CREATE TABLE statement. We can use GENERATED AS IDENTITY with the ALWAYS, DEFAULT or DEFAULT ON NULL keywords and that will affect the way or when the […]
While data warehouses do have their own place, most OLTP databases today are still used to run analytical and DSS type queries and workloads to support real-time decision-enabling information requirement which the business has. Designing a database to cater for this hybrid mix of OLTP and DSS workloads presents its own challenges to the DBA. […]
Very often in our databases we have some very large tables which have a lot of historical and legacy data and the challenge is deciding what is old data and what is current data and even if we do identify the old data we do not need and have moved that data to tape storage, […]
