Home 2022 March

Monthly Archives: March 2022

an artist s illustration of artificial intelligence ai this image represents how machine learning is inspired by neuroscience and the human brain it was created by novoto studio as par

Data Concurrency & Data Consistency.

Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which is the simultaneous access of the same data by multiple...
magnifying glass on book

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


Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within the tablespace frequently grows...
person using macbook pro

Data Guard Protection Modes

Maximum Availability In this protection mode Transactions do not commit until all redo data needed to recover those transactions has been written to the online...

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...
square gap in beige wall

ACID PROPERTY : Transactions

A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL statements so that they are...
set of tool wrench

RAC Tools

Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ... Database Configuration Assistant ... Fleet Patching and Provisioning ... Cluster Verification Utility (CVU): CVU is a...

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

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