Manual Database Creation
The specific methods for creating a database are: With Database Configuration Assistant (DBCA), a graphical…
Read moreOracle
ORA-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 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 moreCreating pluggable database from another pdb, when pdb$seed in in mount state
→ Here we can see that new pluggable database PDB1 created from another pluggable database…
Read moreDatafiles in Oracle (Physical Storage)
Overview of Data Files At the operating system level, Oracle Database stores database data in…
Read moreOracle Database 19c – Practical & Assignments
PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file…
Read moreSystem Change Numbers (SCNs)
A system change number (SCN) is a logical, internal time stamp used by Oracle Database.…
Read morePassword File management in 12C/19C
Below are the list of additional privileged user in 12c apart from the privileged user…
Read moreDetermining the Size of Oracle database tables and indexes
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…
Read moreOracle Instance and Database Shutdown Sequence
In a typical use case, you manually shut down the database, making it unavailable for…
Read moreASH (Active Session History) Report in Oracle
Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions…
Read moreDatabase Buffer Cache : SGA Component of Oracle
The database buffer cache, also called the buffer cache, is the memory area that stores…
Read moreContents in Flash Recovery Area(FRA)?
Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups.…
Read moreControl files in Oracle (Physical Storage)
The database control file is a small binary file associated with only one database. Each…
Read moreFlush SQL Statement from Shared Pool
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes…
Read moreOverview of Checkpoints !!
A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database…
Read moreDynamic Performance Views in Oracle
The dynamic performance views are special views that are continuously updated while a database is…
Read moreOracle Database Locking Mechanism – 1
A lock is a mechanism that prevents destructive interactions. Interactions are destructive when they incorrectly…
Read moreOPATCHAUTO-72083: Performing bootstrap operations failed OPATCHAUTO-72146: Failed to load patch !!
Problem:While patching 19.3 GRID_HOME with July2019 RU patch 19.4 I got this error: Solution:The problem…
Read moreInstance Recovery in Oracle
Instance recovery is the process of applying records in the online redo log to data…
Read moreOracle Instance and Database Startup Sequence
Typically, you manually start an instance, and then mount and open the database, making it…
Read more