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

On Jan 23, 12: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.

Works fine for me hpux 64 bit 10.2.0.3 Received on Wed Jan 23 2008 - 10:00:05 CST