Re: Single record insert intermittently slow

From: Rich <>
Date: Thu, 27 Oct 2011 13:42:01 -0700
Message-ID: <>

Thanks for the reply Grzegorz.

I don't want to do anything which might potentially disrupt the issue we have right now.
This issue is only on this instance and we cannot repro at will, yet. So, process level tracing is out of the question currently as that has potential to crash a process.
Also, this is a production instance (our staging area, so not very heavy load in any respect), so I have to be somewhat careful.

We can't switch to SecureFiles without a LOT of testing and I don't think that's the direction we would/will take anyway.

For me to be able to post AWR, I'd have to sanitize it which (at this point) is too much trouble.

As previously posted, no enqueue issues that I've seen throughout this issue.

Thanks again,

On Thu, Oct 27, 2011 at 10:36 AM, Grzegorz Goryszewski <> wrote:
> Hi,
>  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
> profile
> --
> -- Author:      Tanel Poder
> -- Copyright:   (c)
> --
> from
> 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 ?
> Disclaimer:
> Dont blame me for any production issues related to my advice :)
> Regards
> GregG
> ----------------------------------------------------------------
> Konkurs: Wygraj nowoczesna suszarke do wlosow!
> Sprawdz >>>
> --

Received on Thu Oct 27 2011 - 15:42:01 CDT

Original text of this message