Re: Strange session blocking issue
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: Martin Berger <martin.a.berger@xxxxxxxxx>
- Date: Fri, 21 Jan 2011 21:40:34 -0300
Well, we got an EM alert saying SESSION x (I don't remember the session
number) is blocking 1153 sessions...
Apparently it was a latch contention...
weird
Alan.-
On Fri, Jan 21, 2011 at 6:15 PM, Martin Berger <martin.a.berger@xxxxxxxxx>wrote:
> Alan,
>
> can you specify 'blocking'?
>
> In general, as v$ views are accessing SGA data more or less directly, you
> can need a latch so the x$ 'tables' are not changed during access. Of course
> that can take a while.
>
> Where came the alert from?
>
> Martin
>
>
> Am 21.01.2011 um 22:01 schrieb Guillermo Alan Bort:
>
> A colleague was running this query:
>
> select *
>
> from v$sql_bind_capture
>
> where sql_id in (
>
> 'b501tjnwb31zw',
>
> 'd88z78qwf8rn6',
>
> 'd0w015tn4pc1j',
>
> '9rwzxss9t1quz'
>
> );
>
>
>
>
> And we got an alert that he was blocking other sessions.
>
> Anyone ever experienced something like this?
>
> Alan.-
>
>
>
Other related posts:
