library cache: mutex X wait event
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Sat, 8 Sep 2012 09:26:01 -0700
Message-ID: <CAHDOOG7Pi9KoRc+YcFFri4ZNkixZsSXU3LRnTBLh0U8+wCeHCg_at_mail.gmail.com>
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
Date: Sat, 8 Sep 2012 09:26:01 -0700
Message-ID: <CAHDOOG7Pi9KoRc+YcFFri4ZNkixZsSXU3LRnTBLh0U8+wCeHCg_at_mail.gmail.com>
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-lReceived on Sat Sep 08 2012 - 11:26:01 CDT