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>
ERROR at line 1:
ORA-01013: user requested cancel of current operation
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;
.......
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. Received on Tue Jan 22 2008 - 23:23:46 CST