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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > > > 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" > > <[EMAIL PROTECTED]> > > > > > 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: [EMAIL PROTECTED] > > > > > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).