I suggest you get the size of you table from table(s) SELECT segment_name, sum(bytes) FROM DBA_SEGMENTS group by segment_name Then do the transaction and execute the query again. and substract, the differenct is what you want. ----- Original Message ----- From: "DENNIS WILLIAMS" <DWILLIAMS@xxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, March 16, 2004 6:03 PM Subject: RE: How to calculate the size of a transaction? > Ashoke - > In answer to the simple question, how to find the bytes in a row of a > table, the simplest way is to analyze the table, then look at AVG_ROW_LEN > column in USER_TABLES view. > > Dennis Williams > DBA > Lifetouch, Inc. > dwilliams@xxxxxxxxxxxxx > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mandal, Ashoke > Sent: Tuesday, March 16, 2004 4:01 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: How to calculate the size of a transaction? > > > Hi Stephane, > > One of my customer uses some application and this application inserts one > row to some tables and multiple rows to some of the tables as part one > single transaction. We know the list of the tables and the common key id, > which can be used to identify all the rows in all of these tables related to > this key id. He is asking how much space in bytes are used to store the data > inserted as part of this transaction. How can I get the actual size of a row > in all of these tables. Then I can probably add the row size from all the > affected tables to get the size of the transaction. > > I hope this explains my requirement better. > > Thanks, > Ashoke > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephane Faroult > Sent: Tuesday, March 16, 2004 3:47 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: How to calculate the size of a transaction? > > > "Mandal, Ashoke" wrote: > > > > Greetings, > > > > I have a set of tables, in which one or multiple records get inserted as > part of a transaction. > > Probably I need to find out the actual size of each row of these tables > and find out the no. of rows inserted as part this transaction and then add > all these row size to get the transaction size. > > > > Does anybody have any standard set of scripts, which could be used to find > out the transaction size. > > > > Thanks for your help, > > Ashoke > > Ashoke, > > I don't get what you are aiming for. 'transaction size' ? What's that > ? A transaction is a logical unit of work. Methinks that if you are > interested in the byte-shifting work, you'd rather have a look at > V$ROLLSTAT and the amount of redo you generate. Certainly more > meaningful figures to me. > > -- > Regards, > > Stephane Faroult > Oriole Software > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------