Re: weird

Sorry, I can't help it. But anyway, I will take your advice and keep away from Oracle for a while. There are few DB2 materials I want to go through... (just joking ;)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, September 21, 2003 10:19 PM

>
> Yeah. What he said. And you make the rest of us look bad.
>
> For the record, I replaced my ailing 27-inch color TV with a new 32-inch
and
> started a new game of Final Fantasy VII. No stinkin' Oracle for me this
> weekend.
>
> > -----Original Message-----
> >
> >
> > Tanel,
> >
> > This is above and beyond the call of duty.
> >
> > Now you need to step away from the computer...
> >
> > Jared
> >
> > On Sun, 2003-09-21 at 08:29, Tanel Poder wrote:
> > > Hi!
> > >
> > > After spending half of Saturday and Sunday digging around
> > x$ktcxb and other
> > > interesting views I actually realized that the answer is
> > way simpler :)
> > >
> > > TADDR column in v$session points to *current* transaction
> > state object, that
> > > means if recursive transaction is needed for wrapping or
> > extending rollback
> > > segment, TADDR points to this recursive transaction. When
> > your query happens
> > > to select at the same time, it sees statistics for the
> > small recursive
> > > transaction, not your big one.
> > >
> > > You should have been joining v$transaction.ses_addr with
> > v$session.saddr
> > > instead of v$session.taddr with v$transaction.addr.
> > > (note there is a column recursive in v$transaction which
> > allows to filter
> > > recursive transactions out)
> > >
> > > I tested it on 9.2.0.3 with AUM, but it should be the same
> > in earlier
> > > versions.
> > > Tanel.
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Sunday, September 21, 2003 4:04 PM
> > >
> > >
> > > >
> > > > 8.1.7.4 No AUM.
> > > > Either it was something goofy in the database, or
> > something clobbered some
> > > > bytes as they were going from the host machine to my
> > telnet session ...
> > > > which afaik would also be wierd since TCP/IP is supposed
> > to guarantee
> > > > delivery.
> > > >
> > > > The terminal session is on a Windows box ... maybe that's it!
> > > >
> > > > > -----Original Message-----
> > > > >
> > > > > Which version are you on?
> > > > > Just wondering if it might have something to do with some bug
> > > > > in automatic
> > > > > undo management?
> > > > >
> > > > > Tanel.
> > > > >
> > > > > ----- Original Message -----
> > > > > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > > > > Sent: Friday, September 19, 2003 6:09 PM
> > > > >
> > > > >
> > > > > >
> > > > > > No question here. Just something weird. This is a
> > > > > long-running insert
> > > > > with
> > > > > > NO NONE ZERO ZIP ZILCH NADA commit. It makes me wonder if
> > > > > something weird
> > > > > > is going on, or if I am overlooking something in the query.
> > > > > >
> > > > > > SQL> select a.username,sum(b.used_ublk) x from v$session a,
> > > > > v$transaction
> > > > > b
> > > > > > where a.taddr=b.addr group by a.username;
> > > > > >
> > > > > > USERNAME X
> > > > > > ------------------------------ ----------
> > > > > > SYSTEM 418
> > > > > >
> > > > > > 1 row selected.
> > > > > >
> > > > > > SQL> /
> > > > > >
> > > > > > USERNAME X
> > > > > > ------------------------------ ----------
> > > > > > SYSTEM 893
> > > > > >
> > > > > > 1 row selected.
> > > > > >
> > > > > > SQL> /
> > > > > >
> > > > > > USERNAME X
> > > > > > ------------------------------ ----------
> > > > > > SYSTEM 2
> > > > > >
> > > > > > 1 row selected.
> > > > > >
> > > > > > SQL> /
> > > > > >
> > > > > > USERNAME X
> > > > > > ------------------------------ ----------
> > > > > > SYSTEM 3181
> > > > > >
> > > > > > 1 row selected.
> > > > > >
> > > > > > SQL> /
> > > > > >
> > > > > > USERNAME X
> > > > > > ------------------------------ ----------
> > > > > > SYSTEM 3204
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > > --
> > > > > > Author: Stephen Lee
> > > > > > INET: Stephen.Lee_at_DTAG.Com
> > > > > >
> > > > > > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > > > > > San Diego, California -- Mailing list and web
> > > > > hosting services
> > > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > > (or the name of mailing list you want to be removed
> > from). You may
> > > > > > also send the HELP command for other information
> > (like subscribing).
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > --
> > > > > Author: Tanel Poder
> > > > > INET: tanel.poder.003_at_mail.ee
> > > > >
> > > > > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > > > > San Diego, California -- Mailing list and web
> > hosting services
> > > > >
> > ---------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed
> > from). You may
> > > > > also send the HELP command for other information (like
> > subscribing).
> > > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Stephen Lee
> > > > INET: Stephen.Lee_at_DTAG.Com
> > > >
> > > > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > > > San Diego, California -- Mailing list and web
> > hosting services
> > > >
> > ---------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed
> > from). You may
> > > > also send the HELP command for other information (like
> > subscribing).
> > > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Tanel Poder
> > > INET: tanel.poder.003_at_mail.ee
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> > hosting services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: Stephen.Lee_at_DTAG.Com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).