Re: A potential bug (infinite loop) in Oracle: querying v$access
From: shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 23 Jan 2008 09:40:06 +0100
Message-ID: <4796fd6d$0$85785$e4fe514c@news.xs4all.nl>
>> Making a long query:
>>
>> select distinct name from all_source;
>> .......
>> SYS_YOID0000052452$
>> ......
>> 3196 rows selected.
>>
>> Ok no problem.
>>
>> select distinct owner from v$access
>> SQL> /
>> select distinct owner from v$access
>> *
>> ERROR at line 1:
>> ORA-01013: user requested cancel of current operation
>>
>> I had to terminate it as it become non-terminating.
>>
>> "select owner from v$access" returns a mere 193 rows, and it cannot
>> sort it?
>>
>> I suspect there is exists an infinite loop somewhere.
>>
>> This was attempted on 10gR2, 11gR1 and both had the same problem.
Date: Wed, 23 Jan 2008 09:40:06 +0100
Message-ID: <4796fd6d$0$85785$e4fe514c@news.xs4all.nl>
"Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> schreef in
bericht
news:38ae4253-4519-44ed-bbbb-618154c440e8_at_d70g2000hsb.googlegroups.com...
> On Jan 23, 9:23 am, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
>> Making a long query:
>>
>> select distinct name from all_source;
>> .......
>> SYS_YOID0000052452$
>> ......
>> 3196 rows selected.
>>
>> Ok no problem.
>>
>> select distinct owner from v$access
>> SQL> /
>> select distinct owner from v$access
>> *
>> ERROR at line 1:
>> ORA-01013: user requested cancel of current operation
>>
>> I had to terminate it as it become non-terminating.
>>
>> "select owner from v$access" returns a mere 193 rows, and it cannot
>> sort it?
>>
>> I suspect there is exists an infinite loop somewhere.
>>
>> This was attempted on 10gR2, 11gR1 and both had the same problem.
> > 9.2.0.8/Win32 doesn't have this issue: select distinct owner from v > $access returns 3 rows instantaneously as expected. I don't have a > 10gR2 or 11gR1 instance handy to test, but if this issue is definitely > reproducible on these releases (maybe on certain platforms only,) I > suggest that you open a SR with Oracle Support for it as it looks like > a regression or platform-dependent bug. > > Regards, > Vladimir M. Zakharychev > N-Networks, makers of Dynamic PSP(tm) > http://www.dynamicpsp.com >
Select distinct name from all_source: 6194 rows returned Select distinct owner from v$access: 13 rows returned. 10.1.0.5.0 on Windows: no errors.
Shakespeare Received on Wed Jan 23 2008 - 02:40:06 CST