Posts by Judith Roizman

ORACLE: BLOCKING QUERIES

A blocking query in Oracle is an SQL statement that causes other queries or transactions…

Why Unused Database Space Matters

Identifying and Reducing Unused Database Space Managing database storage efficiently is crucial for ensuring SQL…

HOST: DISK IOPS

Disk IOPS (Input/Output Operations Per Second) measures the number of read and write operations performed…

SQL: CACHE UTILIZATION

In SQL Server as well as in Oracle databases, cache utilization is closely related to…

ORACLE: PGA CACHE HIT RATIO

In Oracle, memory management revolves around two main areas: SGA (System Global Area): This shared…

ORACLE: LAST DR SYNC

Log shipping in Oracle database involves continuously sending redo logs from the primary database to…
Menu
Skip to content