Oracle Database parameter MAX_STRING_SIZE controls the maximum size of VARCHAR2, NVARCHAR2, and RAW data types in SQL. From Oracle Database 12c onwards, table column(s) length can be modified to greater than 4000 characters when this parameter value is set to EXTENDED. Allowed values for this parameter are: STANDARD: Default value. Means that the length limits […]
oracle 12c
Connecting PDB in Oracle 12c and 19c
To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba’ wherever necessary. Method 1 alter session set container = pdbName; Method 2 For other methods, you need to know the service-name for the PDB: – Get the service name for the PDB: SELECT name || ‘ […]
Establish Connection in CDB and PDB
When it comes to Multi-tenant architecture, one question that comes to our mind is how to connect to container database and pluggable database. Today we will see all possible ways to connect to the container database. Obviously, we connect database using service name for the non-local connection. When we create CDB, a service is created […]
How to Use Startup, Shutdown, and Alter Database commands in Oracle 12c
Before 12c there are only a few commands available for startup and shutdown but if we follow that we end up starting and stopping only cdb. The commands in 12c to start and shutdown the CDB and PDB are a little different than the previous version. Below list of commands were used in earlier versions […]
Out-of-Place Refresh Option: Oracle 12c New Feature
A new refresh option has been introduced to improve materialized view refresh performance and availability in Oracle Database 12c Release 1. This refresh option is called out-of-place refresh. It uses outside tables during refresh instead of the existing “in-place” refresh that directly applies changes to the materialized view container table. This option works with all […]
Oracle Net New Features in Oracle Database 12c
Oracle Net is the communication software that enables a network session between a client application and an Oracle database. After a network session is established, Oracle Net acts as a data courier for the client application and the database. The following are the new features in Oracle Net Services: Larger Session Data Unit Sizes Oracle […]
How to Enable or Disable Veritas ODM for Oracle database 12.1.0.2, 18c and 19c
This post describes the procedures for Enable/Disable Oracle Disk Manager driver for Oracle Database 12.1.0.2, 18c, and 19c. We assume the Veritas ODM driver is already installed, mounted, and available. Follow the steps outlined below to enable/disable ODM for the Oracle database (note that with different versions of the Solaris OS, the path may change […]
How to Enable or Disable Veritas ODM for Oracle database 12.1.0.1
This post describes the procedures for Enable/Disable Oracle Disk Manager driver for Oracle Database 12.1.0.1. We assume the Veritas ODM driver is already installed, mounted, and available. Follow the steps outlined below to enable/disable ODM for the Oracle database (note that with different versions of the Solaris OS, the path may change to the ODM […]
How to Connect to an Oracle Pluggable Database (PDB)
When connecting to a pluggable database, a valid service connection string that points to its service (previously configured and started) MUST always be provided, whether the connection is attempted locally or remotely: $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jul 30 17:32:15 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. […]
How To Find Creation Time of Oracle Pluggable Database (PDB)
Below query can be used to for PDB creation/cloning time. COLUMN DB_NAME FORMAT A10 COLUMN CON_ID FORMAT 999 COLUMN PDB_NAME FORMAT A15 COLUMN OPERATION FORMAT A16 COLUMN OP_TIMESTAMP FORMAT A10 COLUMN CLONED_FROM_PDB_NAME FORMAT A15 SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME FROM CDB_PDB_HISTORY WHERE CON_ID > 2 ORDER BY CON_ID; Here is a sample output […]