Re: A potential bug (infinite loop) in Oracle: querying v$access
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 23 Jan 2008 19:35:55 +0100
Message-ID: <747b9$4797890b$524b5c40$4850@cache5.tilbu1.nb.home.nl>
>
> 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
Date: Wed, 23 Jan 2008 19:35:55 +0100
Message-ID: <747b9$4797890b$524b5c40$4850@cache5.tilbu1.nb.home.nl>
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 upReceived on Wed Jan 23 2008 - 12:35:55 CST