ASH (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 MoreLIKE Operator : Pattern-matching Conditions
The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test…
Read MoreControl files in Oracle (Physical Storage)
The database control file is a small binary file associated with only one database. Each…
Read MoreProtected: Workshop: Generative AI Resources
There is no excerpt because this is a protected post.
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 More