Re: Simple Insert tuning

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 1 Dec 2017 10:17:10 -0500

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: