Re: Single record insert intermittently slow
Date: Thu, 27 Oct 2011 19:36:55 +0200
is there any chance You can use and share with us output from Tanel's
- File name: oStackProf.sql ( Oradebug short_Stack Profiler )
- Purpose: Take target process stack samples and show an execution
- Author: Tanel Poder
- Copyright: (c) http://www.tanelpoder.com
during slowness, we can see whats going on on calls level maybe that
will help .
Btw is there any chance You can switch to securefiles LOBS ? And can You show awr report from that period, maybe there is some HWM enqueue issue ?
Dont blame me for any production issues related to my advice :) Regards
Konkurs: Wygraj nowoczesna suszarke do wlosow! Sprawdz >>> http://linkint.pl/f2a72
http://www.freelists.org/webpage/oracle-l Received on Thu Oct 27 2011 - 12:36:55 CDT