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

From: Peter Teoh <htmldeveloper_at_gmail.com>
Date: Tue, 22 Jan 2008 21:23:46 -0800 (PST)
Message-ID: <cd23ee24-eb43-4ace-b399-292256eb417c@e23g2000prf.googlegroups.com>

Making a long query:

select distinct name from all_source;
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. Received on Tue Jan 22 2008 - 23:23:46 CST

Original text of this message