Re: V$ Views
From: <art_at_unsu.com>
Date: Wed, 27 May 2009 12:15:24 -0700 (PDT)
Message-ID: <f2d954d7-6d5d-4a02-8ffb-0a248a3a8f21_at_x5g2000yqk.googlegroups.com>
On May 27, 1:35 pm, ddf <orat..._at_msn.com> wrote:
> On May 27, 12:44 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > On May 27, 10:13 am, ddf <orat..._at_msn.com> wrote:
>
> > > On May 27, 11:42 am, a..._at_unsu.com wrote:
>
> > > Which release of Oracle are you using? My example was run on
> > > 11.1.0.6.0; running on 10.2.0.3.0 produces similar results:
>
> > That's why I punted on this one :-) I seem to recall even oracle
> > couldn't get it straight as to when it changed definitions, not to
> > mention things like bug 7580277.
>
> > jg
> > --
> > _at_home.com is bogus.
> > "According to V$SESSION_LONGOPS this query has been running since
> > 1988. "
>
> I try, I fail, I get up and move on. If Oracle can't figure this out
> who am I to do any better? :D
>
> David Fitzjarrell
Date: Wed, 27 May 2009 12:15:24 -0700 (PDT)
Message-ID: <f2d954d7-6d5d-4a02-8ffb-0a248a3a8f21_at_x5g2000yqk.googlegroups.com>
On May 27, 1:35 pm, ddf <orat..._at_msn.com> wrote:
> On May 27, 12:44 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > On May 27, 10:13 am, ddf <orat..._at_msn.com> wrote:
>
> > > On May 27, 11:42 am, a..._at_unsu.com wrote:
>
> > > Which release of Oracle are you using? My example was run on
> > > 11.1.0.6.0; running on 10.2.0.3.0 produces similar results:
>
> > That's why I punted on this one :-) I seem to recall even oracle
> > couldn't get it straight as to when it changed definitions, not to
> > mention things like bug 7580277.
>
> > jg
> > --
> > _at_home.com is bogus.
> > "According to V$SESSION_LONGOPS this query has been running since
> > 1988. "
>
> I try, I fail, I get up and move on. If Oracle can't figure this out
> who am I to do any better? :D
>
> David Fitzjarrell
Dave,
now why would you expect Oracle to figure anything out? Received on Wed May 27 2009 - 14:15:24 CDT