Home 2022 March

Monthly Archives: March 2022

magnifying glass on book

12.2 Index Advanced Compression “High”.

0
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

0
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

0
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...
a close up shot of a command key

Protected: UNDO BLOCK

0
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

0
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

0
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...
railings around hatch on asphalt carriageway

Database Link

0
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.

0
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...