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…
Menu
Skip to content