ORACLE: BLOCKING QUERIES
A blocking query in Oracle is an SQL statement that causes other queries or transactions…
SQL: CACHE UTILIZATION
In SQL Server as well as in Oracle databases, cache utilization is closely related to…
ORACLE: DATABASE CPU RATIO
The database CPU ratio in Oracle databases refers to the ratio of CPU consumption by…
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…
CONNECTION: QUERY SMALLER OR LARGER THAN
A Query Connection is a tool designed to track specific queries that return numeric values,…
ORACLE: LONG RUNNING QUERIES
An Oracle long-running query is one that takes a significant amount of time to execute,…
MSSQL: INTERNAL MEMORY PRESSURE
SQL Internal memory pressure is an SQL Memory metric that measures memory used by the…
INCREASE IN QUERIES EXCECUTIONS
This alert provides data about queries running within a specific range of seconds. When there’s…
SQL: LOGIN FAILED ATTEMPT
A Login exception is a failed attempt to log in to the database instance during…
