2 min read
Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which is the simultaneous access of...
Month: March 2022
2 min read
2 min read
12.2 Index Advanced Compression “High” Let’s begin by creating a table and explicitly creating a NOCOMPRESS index in the WHALE...
4 min read
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...
2 min read
Normally if you are trying to shrink a compressed table lets say you get below error, and the trick to...
2 min read
Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within...
3 min read
SYSTEM Tablespace is Growing Abnormally in 12c My SYSTEM tablespace was growing rapidly. This was happening in my test environment....
3 min read
A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL...
2 min read
Cluster Verification Utility (CVU) ... Oracle Enterprise Manager ... SQL*Plus ... Server Control (SRVCTL) ... Database Configuration Assistant ... Fleet...
2 min read
Adding Disks to a Disk Group is done with the "alter diskgroup" command.Oracle provides the alter diskgroup command to adding...
2 min read
A database link (DBlink) is a definition of how to establish a connection from one Oracle database to another. Type...
2 min read
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1) Immediate 2) Deferred 3) False...
