Home 2021 November

Monthly Archives: November 2021

ASH (Active Session History) Report in Oracle

Oracle ASH report introduced in Oracle 10g release 2. ASH collects samples of active sessions every second (waiting for non-idle events, or on the CPU...
pile of folders

Database Buffer Cache : SGA Component of Oracle

The database buffer cache, also called the buffer cache, is the memory area that stores copies of data blocks read from data files. A buffer is a main memory...
a detective turning the switch of a vintage recorder

Contents in Flash Recovery Area(FRA)?

Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups. – datafile: for RMAN image copies. – autobackup: for control file autobackups. –...