Re: A potential bug (infinite loop) in Oracle: querying v$access

From: joel garry <joel-garry_at_home.com>
Date: Wed, 23 Jan 2008 14:07:14 -0800 (PST)
Message-ID: <e49fc97b-6a10-4080-bbf1-5d2da4a74f45@s13g2000prd.googlegroups.com>


On Jan 23, 4:58 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Jan 23, 12:23 am, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
>
> > This was attempted on 10gR2, 11gR1 and both had the same problem.
>
> I was able to reproduce this problem on Oracle 10.2.0.2 with the
> Oracle October 2006 CPU on 64 bit Windows 2003.
>
> From the udump trace file:
> ksedmp: internal or fatal error
> ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
> [__intel_new_memcpy+610] [PC:0x3236532] [ADDR:0x0] [UNABLE_TO_READ] []
> Current SQL statement for this session:
> select distinct owner from v$access

Looks like the fix for Note:353663.1 doesn't hit all the possibilities. But check out Note:415450.1, perhaps a windowsspecific  problem, since there is that "intel" argument. Looks like there are some "unable to duplicate" similar problems, too.

No problem for me with hp-ux 9206.

jg

--
@home.com is bogus.
"When the pin is pulled, Mr. Grenade is not our friend." - U.S.
Marine Corps
Received on Wed Jan 23 2008 - 16:07:14 CST

Original text of this message