Re: Simple Insert tuning
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 1 Dec 2017 10:17:10 -0500
Message-ID: <9e8bcd56-fb66-e845-3ee7-facdb38c7a66_at_gmail.com>
Date: Fri, 1 Dec 2017 10:17:10 -0500
Message-ID: <9e8bcd56-fb66-e845-3ee7-facdb38c7a66_at_gmail.com>
I agree 100%. In the age of AWR and ASH reports, people are no longer collecting trace files. Analyzing the trace file is the only way of figuring out what the problem is.
On 11/30/2017 05:25 PM, dba Wilson wrote:
> Hi Sanjay,
>
>
> You can do a 10046 trace. Sometimes it might be caused by recursive
> calls, like triger.
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 01 2017 - 16:17:10 CET