Understanding PL/SQL Blocks
Block Types A PL/SQL program comprises one or more blocks. These blocks can be entirely separate or nested within …
Block Types A PL/SQL program comprises one or more blocks. These blocks can be entirely separate or nested within …
The Problem When attempting to start the OPMN services the following error occurs: opmnctl: starting opmn and all …
You can specify the maximum size for any PDB database using STORAGE clause in CREATE PLUGGABLE DATABASE command. If we …
The database has a program that performs a huge sort operation (e.g. end of the year reporting process). This may cause …
This post lists out different administrative tasks you can perform in a container database (CDB) and pluggable database …
Question: How to resize the TEMPFILE(s) for a temporary tablespace after they have grown larger than needed? Large sort …
This post explains why and how to create groups of temporary tablespaces. Grouping temporary tablespaces within a single …
Sometimes it is necessary to move a Datafile to another Location (eg. Mountpoint, ASM Diskgroup, etc.) due to Space …
The Setup We will be using below setup for the purpose of this post: CDB name:CDB1 PDB name: pdbtest CDB1 …
TDE was introduced as of 10gR2 ( 10.2.0.1 ). In 12c TDE provides a completely different interface to manage the wallet …
Rolling Forward a Physical Standby Database Using the RECOVER FROM SERVICE Command A standby database is a …