|
||||
|
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 […] In 12.1.0.1, one must have a trigger or script to open all PDB’s once the CDB is restarted. But from 12.1.0.2, there is a new option “Save State” for alter pluggable database command. Let’s test it This is the status of my PDB’s select name,open_mode from v$pdbs; NAME OPEN_MODE —————————— ———- PDB$SEED READ ONLY PDB3 […] Opatchauto failing with error CRS 6706 : Oracle Clusterware Release patch level (‘nnnnnn’) does not match Software patch level (‘nnnnnn’). This can be due to with two reasons One of the node in the cluster have different patches than other The patch level from one node to other is different. How to find it? $/u01/app/12.1.0.2/grid/bin/kfod […] With recent PSU Patch (Jan18) , while runnin datapatch the following issue occurred. Error: prereq checks failed! patch 22139226: The pluggable databases that need to be patched must be in upgrade mode Prereq check failed, exiting without installing any patches. There is an option called “skip_upgrade_check” for datapatch. $ ./datapatch -verbose -skip_upgrade_check SQL Patching tool […] Starting 12c, we can export a view and import it as table instead of view using data pump. SQL> create view emp_dept as select empno, ename, dept.deptno , dname from emp, dept where emp.deptno=dept.deptno; View created. expdp directory=DBA_DATAPUMP dumpfile=test.dmp logfile=test.log VIEWS_AS_TABLES=emp_dept_vw Processing object type TABLE_EXPORT/VIEWS_AS_TABLES/TABLE_DATA Total estimation using BLOCKS method: 16 KB Processing object […] Hi, In release 12.2, we can use database link to clone the PDB. Here is the example. SQL> CREATE USER c##clone_dba IDENTIFIED BY clone_dba CONTAINER=ALL; SQL> GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##clone_dba CONTAINER=ALL; SQL> CREATE DATABASE LINK clone_link CONNECT TO c##clone_dba IDENTIFIED BY clone_dba USING ‘pdb1’; SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1@clone_link; […]
Assuming you have completed docker installation on windows and registered with oracle container registry, Read first part here if not yet done This post explain how to create a container for mysql and also show some example of managing container etc. In less than 10 mins mysql database is ready and you can practice […] Hello Assuming you have done the installation of docker and registered to container registry. This post elaborates the weblogic docker usage and how to see logs and manage weblogic. At last of this post I will also show you to run some examples to create additional domain /servers etc with docker samples. In less than […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!