Path: g2news1.google.com!postnews.google.com!d70g2000hsb.googlegroups.com!not-for-mail
From: "Vladimir M. Zakharychev" <vladimir.zakharyc...@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: A potential bug (infinite loop) in Oracle: querying v$access
Date: Tue, 22 Jan 2008 22:55:05 -0800 (PST)
Organization: http://groups.google.com
Lines: 39
Message-ID: <38ae4253-4519-44ed-bbbb-618154c440e8@d70g2000hsb.googlegroups.com>
References: <cd23ee24-eb43-4ace-b399-292256eb417c@e23g2000prf.googlegroups.com>
NNTP-Posting-Host: 91.196.34.22
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1201071306 29075 127.0.0.1 (23 Jan 2008 06:55:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 23 Jan 2008 06:55:06 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d70g2000hsb.googlegroups.com; posting-host=91.196.34.22; 
	posting-account=PAnILQoAAAD84SMI2vqfU32t6U_KSuGX
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.11) 
	Gecko/20071127 Firefox/2.0.0.11,gzip(gfe),gzip(gfe)

On Jan 23, 9:23 am, Peter Teoh <htmldevelo...@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.

9.2.0.8/Win32 doesn't have this issue: select distinct owner from v
$access returns 3 rows instantaneously as expected. I don't have a
10gR2 or 11gR1 instance handy to test, but if this issue is definitely
reproducible on these releases (maybe on certain platforms only,) I
suggest that you open a SR with Oracle Support for it as it looks like
a regression or platform-dependent bug.

Regards,
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com