Object search

Object search

Has an Oracle object been used during a period? The Replay window summarizing Oracle activity provides, among other details, a list of SQL queries that consumed time (elapsed time) or resources (CPU, IOs) during the selected period. The ‘Object search’...
Oracle SE2: Reading CPU Limit with d.side

Oracle SE2: Reading CPU Limit with d.side

CPU Consumption by Oracle The main D.SIDE screen allows real-time monitoring of the overall CPU consumption of our Oracle instances. For this, we have several indicators distributed across 3 different areas of the screen. Example: 1 – he DSIDE instance is hosted...
Period comparison

Period comparison

Why Compare Two Periods? There are various situations when comparing two periods may be necessary. Here are some use cases: Performance Monitoring: Tracking the evolution of load or behavior of an Oracle database. A process took longer than usual: why? A process ran...
Group Matching

Group Matching

WITHOUT BIND VARIABLES, DIAGNOSTICS BECOME MORE COMPLICATED When many individually fast queries are executed, it becomes difficult to determine which SQL statements are the costliest among the Oracle activity. Each query may only take a few milliseconds of elapsed...
Oracle alerting

Oracle alerting

Introduction The D.SIDE alerting module for Oracle allows for the detection of: An increase in activity or consumption: CPU, physical reads, number of sessions, etc. A decrease in activity: fewer queries executed, fewer transactions, etc. A drift in response time for...