2 min read
Normally if you are trying to shrink a compressed table lets say you get below error, and the trick to...
Oracle
2 min read
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....
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...
SQL> create pluggable database PDB1 from DEV1 create_file_dest='+DEV_DG_FLASH'; Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ----------...
4 min read
Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every...
6 min read
PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file with sys password as oracle1...
2 min read
A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur...
2 min read
Below are the list of additional privileged user in 12c apart from the privileged user SYSOPER, SYSDBA, SYSASM. SYSBACKUP : It...
2 min read
Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a...
2 min read
In a typical use case, you manually shut down the database, making it unavailable for users while you perform maintenance...
Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle...
14 min read
The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data...
1 min read
Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups. – datafile: for RMAN image...
4 min read
The database control file is a small binary file associated with only one database. Each database has one unique control...
1 min read
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush...
2 min read
A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally. The term has...
2 min read
The dynamic performance views are special views that are continuously updated while a database is open and in use. Throughout...
3 min read
A lock is a mechanism that prevents destructive interactions. Interactions are destructive when they incorrectly update data or incorrectly alter...
1 min read
Problem:While patching 19.3 GRID_HOME with July2019 RU patch 19.4 I got this error: # export PATCH_LOCATION=/u01/oracle/RU_PATCHES/29708769 # $GRID_HOME/OPatch/opatchauto apply $PATCH_LOCATION...
4 min read
Instance recovery is the process of applying records in the online redo log to data files to reconstruct changes made...
4 min read
Typically, you manually start an instance, and then mount and open the database, making it available for users. You can...
5 min read
The most crucial structure for recovery is the online redo log, which consists of two or more preallocated files that...
