|
||||
|
In this post, we will see few important ASM Disk group Level Enhancements in 18c. DISK_REPAIR_TIME : Increased from 3.5 hrs to 12 Hrs When a disk is taken offline from a disk group , the diskgroup will not immediately dropped as it waits for 3.5 Hrs as DISK_REPAIR_TIME , but now that […] In this post we cover two aspects of new features in 18c. Readonly Oracle Home: A read-only Oracle home separates the software from the database configuration information and log files. This separation enables you to easily share the software across different deployments. A read-only Oracle home also simplifies version control and standardization. To enable the […] Hi From 12cR2 and 18c, you can cancel the session instead of killing it which is long running and consuming time and resources. The following is the syntax for cancelling a SQL statement: ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’; If @INST_ID is not specified, the instance ID of the current session is used. […] Hi, We all aware of, when a table has attribute set with nologging option , those redo will be missed (although redo information there, the data will be missed) and standby will not apply those changes, and this will problematic when you do a switchover or failover unless you use force logging mode. To address […] Starting 18c, we can create a clone of PDB using ASM level mirror copy the diskgroup with a point in time recovery of the PDB database. This will be really helpful when you want to clone the PDB in the same instance and a point-in-time database clone is a full copy of a specific database, […] In 12c, we can have refreshable PDB from one PDB to another PDB via database link. –Manual Refresh CREATE PLUGGABLE DATABASE pdb_ref FROM pdb1@pdb_link REFRESH MODE MANUAL; — Automatically refresh ever 60 minutes. CREATE PLUGGABLE DATABASE pdb_ref FROM pdb1@pdb_link REFRESH MODE EVERY 60 MINUTES; In 18c, this is extended and we can switchover the primary […] In 18c, we can create a schema with no password using NO AUTHENTICATION clause, which can be useful in proxy based authentication. These accounts are called Schema only accounts and not required any authentication mechanism and used only via remote authentication only. SQL . CREATE USER TEST NO AUTHENTICATION; However, these accounts cannot directly connect […] Starting 18c, we can create private temporary tables which can be visible to the session that created it using “Create Private temporary table” command. Following are use cases for private temporary tables When an application stores temporary data in transient tables that are populated once, read few times, and then dropped at the end of […] Starting 18c, A new pool is introduced in SGA called MemOptimize pool to store the frequently access tables (in other words pin your tables in buffer cache) via primary key values. The Memoptimized Rowstore (pool) uses a memory area in the system global area (SGA) called the memoptimize pool that stores the hash indexes of […] This is the first post in the series of 18c Database features. Starting with Oracle Database 18c, you can use the Oracle Preinstallation RPM and the rpm -ivh command to perform an RPM-based single-instance Oracle Database or Oracle Database Client installation. An RPM-based installation performs preinstallation checks, extracts the database software, reassigns ownership of the […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!