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

Peter Teoh 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.

I could reproduce the hanging for 10.2.0.3 on x86_64, but after using

SQL> alter session set optimizer_mode = RULE; or SQL> alter session set optimizer_mode = FIRST_ROWS_n;

it works fine.

Eberhard Niendorf Received on Wed Jan 23 2008 - 15:45:17 CST