RE: value from index block or table block
Date: Sat, 26 Nov 2011 08:53:25 -0500
Message-ID: <01b101ccac42$c59f1d20$50dd5760$_at_rsiz.com>
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?
- 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.
- 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.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Grzegorz Goryszewski
Sent: Thursday, November 24, 2011 12:22 PM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 26 2011 - 07:53:25 CST