Data Concurrency & Data Consistency.
Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which…
Read moreMarch 2022
12.2 Index Advanced Compression “High”.
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a…
Read moreManual Database Creation
The specific methods for creating a database are: With Database Configuration Assistant (DBCA), a graphical…
Read moreORA-10635: Invalid segment or tablespace type problem resolution !!
Normally if you are trying to shrink a compressed table lets say you get below…
Read moreUNDO BLOCK
Space allocation in the UNDO tablespace is unique and does not follow the same rules…
Read moreSYSTEM Tablespace is Growing Abnormally in 12c
SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was…
Read moreACID PROPERTY : Transactions
A transaction is a logical, atomic unit of work that contains one or more SQL…
Read moreRAC Tools
Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ...…
Read moreASM Disk Addition & Deletion
Adding Disks to a Disk Group is done with the “alter diskgroup” command.Oracle provides the…
Read moreDatabase Link
A database link (DBlink) is a definition of how to establish a connection from one…
Read moreParameters which require DB bounce.
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1)…
Read more