Number of Transaction Slots
I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
Re: Number of Transaction Slots
Taking a different tack - it doesn't really matter very much what the maximum is, as you don't want to have more than 5 concurrent transactions per rollback segment or you start losing space in rollback blocks in a big way. (There is a block reuse pool limited to 5 blocks). And you start getting contention on the segment header undo block if the concurrency goes too high. Using a formula instead of just looking is perhaps a bit pointless - minor details can change over time, rapidly making the formula incorrect. As the economist said: Yes, I know it works in practice, but does it work in theory. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 March 2002 21:25 | |Thanks Robert, and thanks once again, Gopal. | |Now, metalink also has a formula for finding the number of transaction |slots (DOC ID: 177926.999), and Steve Adams too explains precisely how he |arrived at that number of 21 slots for a 2K block size at |http://www.ixora.com.au/q+a/0008/29204045.htm without dumping the header |block, from v$TYPE_SIZE. | |But then the metalink has one formula, if the rollback segment has a fixed |number of extents, and another if it has unlimited number of extents. Steve |Adams also does refer to the extent control headers, but I think he's done |either of the one assumptions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
RE: Number of Transaction Slots
The transaction slots are visible as KTUXESLT in X$KTUXE. You can get them using this SQL.. select count(*) ktuxeslt from X$ktuxe group by ktuxeusn; For a complete value you can get the slot size form V$TYPE_SZIE and do a simple math.. Let me know if you can't. I will do that for you Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
RE: Number of Transaction Slots
Rajesh, The transaction slots are clearly visible in the Undo Header dumps. I think this takes some 40 bytes space in the undo header block and this limits the number of ***concurrent** transactions for that undo segment. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
RE: Number of Transaction Slots
Yes, the man is a X$ marvel What that I could remember all of the things that he seems to have at the tip of his emails. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 07, 2002 7:18 PM To: Multiple recipients of list ORACLE-L To give credit where credit is due, this came from my friend K Gopalakrishnan... You mean K 'X$' Gopalakrishnan, don't you ;-) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
RE: Number of Transaction Slots
To give credit where credit is due, this came from my friend K Gopalakrishnan... You mean K 'X$' Gopalakrishnan, don't you ;-) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
Re: Number of Transaction Slots
Basically the total ITL size can't be bigger than 50 percent of the available space for data for the block size. ((db_block_size - ovh) /2) / itl size Anjo. [EMAIL PROTECTED] wrote: I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). winmail.dat
RE: Number of Transaction Slots
Yes, the man is a X$ marvel What that I could remember all of the things that he seems to have at the tip of his emails. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 07, 2002 7:18 PM To: Multiple recipients of list ORACLE-L To give credit where credit is due, this came from my friend K Gopalakrishnan... You mean K 'X$' Gopalakrishnan, don't you ;-) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Number of Transaction Slots
I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Number of Transaction Slots
The transaction slots are visible as KTUXESLT in X$KTUXE. You can get them using this SQL.. select count(*) ktuxeslt from X$ktuxe group by ktuxeusn; For a complete value you can get the slot size form V$TYPE_SZIE and do a simple math.. Let me know if you can't. I will do that for you Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Number of Transaction Slots
To give credit where credit is due, this came from my friend K Gopalakrishnan... The transaction slots are visible as KTUXESLT in X$KTUXE. We can get the number of transaction slots in the rollback segments by select count(*) ktuxeslt from X$ktuxe group by ktuxeusn; The # of transaction slots are determined by the database block size. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Number of Transaction Slots
Rajesh, The transaction slots are clearly visible in the Undo Header dumps. I think this takes some 40 bytes space in the undo header block and this limits the number of ***concurrent** transactions for that undo segment. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 12:04 PM To: Multiple recipients of list ORACLE-L I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Number of Transaction Slots
Basically the total ITL size can't be bigger than 50 percent of the available space for data for the block size. ((db_block_size - ovh) /2) / itl size Anjo. [EMAIL PROTECTED] wrote: I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Number of Transaction Slots
You've already got the main answer from KG and RF. The figures on Metalink look much too high - but they might be from an earlier version of Oracle. The size is strongly version dependent. In Oracle 9 (automatic UNDO only) the figures are closer to: 4K= 22 8K= 48 In manual rollback, viz Oracle 8 4K= 47 (or maybe 48) Roughly speaking each time you double the block size you double and add a few for the number of slots. To dump a rollback header segment block, the easy option is: alter system dump undo header segment name; The are a necessity for automatic undo headers in Oracle 9 because their names start with an underscore; they are optional for manual rollback segments Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 March 2002 20:21 |I believe someone else had asked this question before, but I did not see a |reply. Does anyone know the number of transaction slots in the rollback |segment header for block sizes of 4k, 8k, et all? | |From what I have read, for a block size of 2K, its 21 transaction slots. |(Steve Adams at www.ixora.com.au) |For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) | |As per Metalink: | |2K - 31 |4K - 67 |8K - 140 | |Different answers? What does it depend on? OS Version, Oracle Version, |number of extents in rollback segment?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Number of Transaction Slots
Anjo, Quick, correct you answer before anyone else gets in there. The guy is asking about the transaction table in the rollback segment header, not about the ITL. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 March 2002 21:06 |Basically the total ITL size can't be bigger than 50 percent of the |available space for data for the block size. ((db_block_size - ovh) /2) / |itl size | |Anjo. | | | |[EMAIL PROTECTED] wrote: | | I believe someone else had asked this question before, but I did not see a | reply. Does anyone know the number of transaction slots in the rollback | segment header for block sizes of 4k, 8k, et all? | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Number of Transaction Slots
Thanks Robert, and thanks once again, Gopal. Now, metalink also has a formula for finding the number of transaction slots (DOC ID: 177926.999), and Steve Adams too explains precisely how he arrived at that number of 21 slots for a 2K block size at http://www.ixora.com.au/q+a/0008/29204045.htm without dumping the header block, from v$TYPE_SIZE. But then the metalink has one formula, if the rollback segment has a fixed number of extents, and another if it has unlimited number of extents. Steve Adams also does refer to the extent control headers, but I think he's done either of the one assumptions. Can someone take a look at both the articles, and confirm if its' really so. Thanks a Ton Raj Freeman, Robert To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Robert_Freemacc: [EMAIL PROTECTED]Subject: RE: Number of Transaction Slots Sent by: [EMAIL PROTECTED] om March 07, 2002 03:23 PM Please respond to ORACLE-L To give credit where credit is due, this came from my friend K Gopalakrishnan... The transaction slots are visible as KTUXESLT in X$KTUXE. We can get the number of transaction slots in the rollback segments by select count(*) ktuxeslt from X$ktuxe group by ktuxeusn; The # of transaction slots are determined by the database block size. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Thursday, March 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Number of Transaction Slots
Taking a different tack - it doesn't really matter very much what the maximum is, as you don't want to have more than 5 concurrent transactions per rollback segment or you start losing space in rollback blocks in a big way. (There is a block reuse pool limited to 5 blocks). And you start getting contention on the segment header undo block if the concurrency goes too high. Using a formula instead of just looking is perhaps a bit pointless - minor details can change over time, rapidly making the formula incorrect. As the economist said: Yes, I know it works in practice, but does it work in theory. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 07 March 2002 21:25 | |Thanks Robert, and thanks once again, Gopal. | |Now, metalink also has a formula for finding the number of transaction |slots (DOC ID: 177926.999), and Steve Adams too explains precisely how he |arrived at that number of 21 slots for a 2K block size at |http://www.ixora.com.au/q+a/0008/29204045.htm without dumping the header |block, from v$TYPE_SIZE. | |But then the metalink has one formula, if the rollback segment has a fixed |number of extents, and another if it has unlimited number of extents. Steve |Adams also does refer to the extent control headers, but I think he's done |either of the one assumptions. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Number of Transaction Slots
I think he is looking for number of KTUXEs per block not KTBIT (ITLs). Does this ITL algorithm same for undo blocks also? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Thursday, March 07, 2002 12:41 PM To: Multiple recipients of list ORACLE-L Basically the total ITL size can't be bigger than 50 percent of the available space for data for the block size. ((db_block_size - ovh) /2) / itl size Anjo. [EMAIL PROTECTED] wrote: I believe someone else had asked this question before, but I did not see a reply. Does anyone know the number of transaction slots in the rollback segment header for block sizes of 4k, 8k, et all? From what I have read, for a block size of 2K, its 21 transaction slots. (Steve Adams at www.ixora.com.au) For a block size of 8K, its 98 (Jonathan Lewis on Metalink - For 8.1.6) As per Metalink: 2K - 31 4K - 67 8K - 140 Different answers? What does it depend on? OS Version, Oracle Version, number of extents in rollback segment?? Regards Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Number of Transaction Slots
To give credit where credit is due, this came from my friend K Gopalakrishnan... You mean K 'X$' Gopalakrishnan, don't you ;-) John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).