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 working) from v$sessions (inactive sessions are not captured). You can run ASH reports to analyze transient performance problems with the database that only occur during specific times. This technique is … Read more
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 address in which the buffer manager temporarily caches a currently or recently used data block. All users concurrently connected to a database instance share access to the buffer cache. It … Read more
Oracle can store different kind of files under FRA: – backupset: for RMAN regular backups. – datafile: for RMAN image copies. – autobackup: for control file autobackups. – flashback: If your database runs in flashback mode, you will see flashback logs in this subdirectory. – archivelog: for Archived redo logs – controlfile: The control file, … Read more