Re: Strange session blocking issue
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: cicciuxdba@xxxxxxxxx
- Date: Fri, 21 Jan 2011 22:15:32 +0100
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:
