Monthly Archives: March 2022
12.2 Index Advanced Compression “High”.
12.2 Index Advanced Compression “High”
Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE tablespace:
SQL> create table WHALE (id...
Manual Database Creation
The specific methods for creating a database are:
With Database Configuration Assistant (DBCA), a graphical tool.With the CREATE DATABASE SQL statement.
1. Specify an Instance Identifier (SID)
The ORACLE_SID environment variable is...
ORA-10635: Invalid segment or tablespace type problem resolution
ORA-10635: Invalid segment or tablespace type problem resolution
Normally if you are trying to shrink a compressed table lets say you get below error, and...
AWR in Multitenant Environment : Oracle 12cR2
AWR in Multitenant Environment : Oracle 12cR2
Starting with Oracle Database 12c Release 1, Multitenancy is the core part of Database, where a container database...
Protected: UNDO BLOCK
Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within the tablespace frequently grows...
SYSTEM Tablespace is Growing Abnormally in 12c
SYSTEM Tablespace is Growing Abnormally in 12c
My SYSTEM tablespace was growing rapidly. This was happening in my test environment. We observe that we were...
ASM Disk Addition & Deletion
Adding Disks to a Disk Group is done with the "alter diskgroup" command.Oracle provides the alter diskgroup command to adding or removing physical disks...
Database Link
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another.
Type of Database Links:
Private database link...
Parameters which require DB bounce.
In v$parameter we can find one column ie. ISSYS_MODIFIABLE.
This column contains three phases: 1) Immediate 2) Deferred 3) False
1. Immediate : We can...