The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: "Vladimir M. Zakharychev" <vladimir.zakharyc...@gmail.com>
Date: Tue, 22 Jan 2008 22:55:05 -0800 (PST)
Local: Wed, Jan 23 2008 1:55 am
Subject: Re: A potential bug (infinite loop) in Oracle: querying v$access
On Jan 23, 9:23 am, Peter Teoh <htmldevelo...@gmail.com> wrote:
> Making a long query: 9.2.0.8/Win32 doesn't have this issue: select distinct owner from v > select distinct name from all_source; > Ok no problem. > select distinct owner from v$access > I had to terminate it as it become non-terminating. > "select owner from v$access" returns a mere 193 rows, and it cannot > I suspect there is exists an infinite loop somewhere. > This was attempted on 10gR2, 11gR1 and both had the same problem. $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, You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||