Re: Increased runtime and 4 xids for one insert

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 11 Apr 2024 21:49:29 -0400
Message-ID: <CAMHX9JJ_xg87jYcwJSA48AyGMYJqsZsePonuMuEcG1ScGg4i0A_at_mail.gmail.com>



Worth correcting myself:

*If you have ASH, you likely have SQL Monitoring too.... *(ASH needs only Diag Pack license, while SQL Monitoring requires Diag+Tuning)

On Thu, Apr 11, 2024 at 2:01 PM Tanel Poder <tanel_at_tanelpoder.com> wrote:

> If you have ASH, you have SQL Monitoring too and if this thing took hours,
> Oracle may already have saved a previous SQL Mon report to data dictionary.
>
> -
> https://mauro-pagano.com/2015/05/04/historical-sql-monitor-reports-in-12c/
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 12 2024 - 03:49:29 CEST

Original text of this message