Re: library cache: mutex X wait event
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: ksmadduri@xxxxxxxxx
- Date: Sun, 9 Sep 2012 20:04:26 +0200
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@xxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
