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

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 23 Jan 2008 11:16:03 -0800 (PST)
Message-ID: <148963e0-1158-4c25-b2b8-29a862e6f292@v67g2000hse.googlegroups.com>


On Jan 23, 1:35 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> Steve Howard wrote:
> > On Jan 23, 7:32 am, Peter Teoh <htmldevelo..._at_gmail.com> wrote:
> >> I tried on Oracle9iR2 (Fedora Core Linux 5) no problem, it returned
> >> immediately - no hanging.
>
> >> But for the earlier post - I forgotten to mentioned they are on Fedora
> >> Core 7.
>
> >> Thanks.
>
> > 10.2.0.3 32 bit on RHAT returned immediately, as did 10.2.0.3 64 bit
> > on AIX 5.2 64 bit.
>
> > Regards,
>
> > Steve
>
> Odd...
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> select distinct owner from v$access;
> select distinct owner from v$access
> *
> ERROR at line 1:
> ORA-01013: user requested cancel of current operation
>
> SQL> exit
> Disconnected from Oracle Database 10g Enterprise Edition Release
> 10.2.0.3.0 - Production
> With the Partitioning, OLAP and Data Mining options
> [oracle102_at_cs-frank03 ~]$ uname -a
> Linux cs-frank03 2.6.18-53.1.4.el5PAE #1 SMP Fri Nov 30 01:21:20 EST
> 2007 i686 i686 i386 GNU/Linux
>
> --
>
> Regards,
> Frank van Bortel
>
> Top-posting in UseNet newsgroups is one way to shut me up

Sorry, that will teach me to post prior to 8AM and my third cuppa' joe :(. I ran it without the distinct, and mine times out as well, on both Linux and AIX. Received on Wed Jan 23 2008 - 13:16:03 CST

Original text of this message