|
||||
|
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, […] As we all aware , that we can have only one instance of Standby running with MRP (redo apply) running in RAC environments. Starting 12.2.0.1, we can have multiple instances on standby side too with following command. Generally, to start the MRP process we use, ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; Now […] In previous post, you have seen the PSM utility installation and using PSM utility, In this post you will learn how to use CLI to effectively manage the databases using commands. #Create Database using Json file C:\Users\gandhi\Desktop>psm dbcs create-service -c 18cdatabase.json Job ID : 1986734 # Check the Service aka database config C:\Users\gandhi\Desktop>psm dbcs service […] Hello All In this post, we see how to install the PSM (Paas Service Manager) CLI utility to manage the cloud operations for Oracle. It has vide range of commands to manage different resources and can be useful to automate the Oracle Cloud Infrastructure operations. The following will be covered in this post. Install Python […] 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 […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!