Re: index maintenance tracing and debugging event
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 20 Jun 2013 00:41:08 +0300
Message-ID: <CAMHX9JJPYHtfLa+sQ27JGAMmNe3U877LafL5Sp424RUsh=wHLA_at_mail.gmail.com>
One way would be to dump redo :)
There's also a following event, which traces delayed index maintenance operations (so, possibly not every single index maintenance op, but only the bulk-delayed ones):
Date: Thu, 20 Jun 2013 00:41:08 +0300
Message-ID: <CAMHX9JJPYHtfLa+sQ27JGAMmNe3U877LafL5Sp424RUsh=wHLA_at_mail.gmail.com>
One way would be to dump redo :)
There's also a following event, which traces delayed index maintenance operations (so, possibly not every single index maintenance op, but only the bulk-delayed ones):
12837, 00000, "Delayed index maintenance debugging event"
// *Document: NO // *Cause: // *Action: Control dumping of debugging information for dealyed maintenanc
It's mentioned here:
*Bug 11795952 - Direct load insert may result in ORA-1 errors during concurrent online index rebuild operation [ID 11795952.8] *
*"If event 12837 is set to level 31, the we see that there are multiple rows being inserted into the index bufffer (kxib) for the same index."*
I've never used it myself, so better ask from support before running this in production ...
-- *Tanel Poder* Enkitec (The Exadata Experts) Training <http://blog.tanelpoder.com/seminar/> | Troubleshooting<http://blog.tanelpoder.com/> | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923> | Voicee App <http://voic.ee/> On Wed, Jun 19, 2013 at 9:04 PM, Josh Collier <Josh.Collier_at_banfield.net>wrote:Received on Wed Jun 19 2013 - 23:41:08 CEST
> Hi,
> I am looking for an event to set that will debug/trace oracle index
> maintenance operations. Such as the type of maintenance that occurs
> automatically when you work on a table with global indexes. I am hoping
> there is an event to set that will give me more information than what I get
> from 10046,
>
> Thanks!
>
> Josh C.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l