November 2021 - ASRblogger

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 working) from v$sessions (inactive sessions…

asrblogger November 26, 2021No Comments

Interview Questions Oracle

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 address in which the buffer…

asrblogger November 25, 2021No Comments

Oracle

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. – flashback: If…

asrblogger November 11, 2021No Comments

Recent Comments.

Anish Kumar on Automatic Diagnostic Repository (ADR)January 14, 2026
I’m really glad it gave you hope, and yes I’ll help with your question.
Anish Kumar on Part 2: NOT NULL & Unique Constraints in SQLJanuary 14, 2026
I’m really glad it gave you hope, and yes I’ll help with your question.
managed service provider solutions on Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)January 14, 2026
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due…
für binance anmelden on Part 2: NOT NULL & Unique Constraints in SQLJanuary 13, 2026
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me…
Skapa ett gratis konto on Automatic Diagnostic Repository (ADR)January 12, 2026
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me…

ASH (Active Session History) Report in Oracle

Database Buffer Cache : SGA Component of Oracle

Contents in Flash Recovery Area(FRA)?

Trending Topics.

Get the Latest Blogging Tips Straight to Your Inbox!