"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 -----------------------------------------------------------------