Re: library cache: mutex X wait event

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sun, 9 Sep 2012 20:04:26 +0200
Message-ID: <CALH8A92zid_Lw1iygt9A1DmbYeMKChjUjECZ_58uxzEWP11b_w_at_mail.gmail.com>

I just tested on my 11.2.0.3 test system, if a user is "grant exempt access policy" - the RLS function is not even called. (Instead of 'is called, but the result is ignored afterwards').

No answer to your question, but maybe it helps to cet a full picture of what's going on.

Martin

On Sat, Sep 8, 2012 at 6:26 PM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
> We have an ebiz concurrent program that is long running.
> It is waiting n library cache: mutex X .
> From note ID 1377998.1 and running this query
>
> select KGLNAOBJ, KGLNAOWN, KGLHDNSP, KGLOBTYP
> from x$kglob where KGLNAHSH= {value of P1}
>
> I found that a custom vpd package ( this package is used to implement vpd
> for non-system users like named sql users). APPS is exempt from vpd
> policies (grant exempt acces policy to apps)
>
> Why is then custom vpd package holding the code that is running through
> apps account.
>
>
> Thank you
>
> Kumar
>
>
> --
> http://www.freelists.org/webpage/oracle-l

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

Received on Sun Sep 09 2012 - 13:04:26 CDT