Re: A potential bug (infinite loop) in Oracle: querying v$access
Date: Wed, 23 Jan 2008 19:35:55 +0100
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.
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
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