RE: value from index block or table block

From: Mark W. Farnham <>
Date: Sat, 26 Nov 2011 08:53:25 -0500
Message-ID: <01b101ccac42$c59f1d20$50dd5760$>

Let me get this straight: You are experiencing the return of incorrect values (meaning either a bug or a corruption) and Oracle Support will not authorize your use of setting an event either at the session or system level?
  1. Have you asked on your SR? Denying your suggestion of using a diagnostic likely to show the problem would create both an interesting legal situation and a troubling review situation for the support analysts involved when you escalate the call.
  2. Make a physical clone using OS level tools and do it there. A physical clone will not repair anything.

Alter session rather than alter system should be sufficient. That was a sloppy cut and paste.

"Our customers are not sheep to be shorn." - An oracle executive I won't out.

Don't be a sheep.



-----Original Message-----
From: [] On Behalf Of Grzegorz Goryszewski
Sent: Thursday, November 24, 2011 12:22 PM To:
Subject: Re: value from index block or table block

On 2011-11-24 10:44, Mark W. Farnham wrote:
> This is a good case for
> ALTER SYSTEM SET EVENTS '10046 trace name context forever, level 12';
> drop table <table_name>; exit;
> to see what is actually going on. Since a drop is actually a long list
> of sql's and proc's, something like
> drop
> --+ gather_plan_statistics
> <table_name>;
> f

Thanks Mark,
We actually did that some time ago, but Oracle support does not allow that . Fortunately looks like, during upgrade to 11g the new index is created on obj$ in place of old with new columns so upgrade should solve our problem in supported way or just fail :) Regards GregG


Received on Sat Nov 26 2011 - 07:53:25 CST

Original text of this message