Re: source of package invalidation
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: chris_stephens@xxxxxxxxxxxx
- Date: Fri, 13 Mar 2009 10:19:15 -0400
Chris,
Logminer is your best friend. Get the invalidation time (if possible)
and look what happens in that period.
You will see inserts/updates to system tables when the package
invalidates and recompiles. You can see what happens just before that.
We had similar problem but in our case the procedure in package was
running for a couple of minutes. You can't recompile a package that is
been executed, so you wait. You can't run a package that's waiting to
be recompiled, so everyone waits.
The end result is a locked up system. In our case it was dynamic DDL
that was "forgotten". LogMiner does not forget.
--
Christo Kutrovsky
Senior DBA
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
On Thu, Mar 12, 2009 at 11:23 AM, Stephens, Chris
<chris_stephens@xxxxxxxxxxxx> wrote:
> We are seeing packages invalidated in our production database and I don’t
> have a clue how to track down the actual cause.
>
>
>
> I’ve taken a look at dba_dependencies and know the potential candidates for
> causing the invalidation but I’m looking to actually identify the chain of
> events that is causing this.
>
>
>
> Is there an oracle event that can be set to generate a trace file for
> something like this?
>
>
>
> Any other ideas on how to track this down?
>
>
>
> Thanks!
>
> Chris
>
>
>
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which it
> is addressed and may contain information that is privileged,
> confidential and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient or the employee or agent
> responsible for delivering this message to the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>
--
Christo Kutrovsky
Senior DBA
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
