Oracle database outage: root cause investigation

jshue — Wed, 08 Feb 2023 12:31:22 GMT

GM everyone,

I am a new-bee in Dynatrace !!!

Here is my question.

On 01/03/2023 around 9:00 am, I have an outage on my Oracle database, no one can connect in anymore.

I went on Dynatrace -> filtered to target DB -> time frame=last 90 days -> Problems

4 entries show up:

1. Failed database connects, Jan 03 10:52 duration=5 min, no root cause, statement 1. failed-connect, 2. commit 3.rollback

2. Response time degradation, Jan 03 10:49 duration=12 min, root cause= User Interface

3. Multiple service problems, Jan 03 09:50 duration=1 h 12 min, root cause=Database, statement 1. update, 2 delete, insert

4. Failed database connects, Jan 03 09:40 duration=1 h 17 min, no root cause, statement 1. failed-connect, 2. commit

In fact I know pretty sure there are some Parallel Query running at the time causing the problem.

Oracle Bug 21384810, Parallel Queries in 12c Spending Time on Recursive Query With /* DS_SKEW */ (Doc ID 2104350.1)

I cannot find the culprit SQL in Dynatrace

--John

Re: Misleading root cause ?

Babar_Qayyum — Tue, 31 Jan 2023 14:16:39 GMT

Hello @jshue

Still, you have a chance to get the benefits of the Oracle DB insight feature before this feature totally vanishes. Just start monitoring your database using the Oracle DB insight.

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/database-insights

Regards,

Babar

topic Oracle database outage: root cause investigation in Open Q&A

Oracle database outage: root cause investigation

Re: Misleading root cause ?