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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 24 Jan 2008 20:14:52 +0100
Message-ID: <98e51$4798e3ac$524b5c40$16981@cache4.tilbu1.nb.home.nl>


joel garry wrote:
> 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 windows-
> specific 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

Reproduces on Linux as well. But I'm on Intel, yes. Don't know what hardware Steve Howard uses for AIX - is AIX 5.2 available for intel?!?

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Thu Jan 24 2008 - 13:14:52 CST

Original text of this message