Re: How to calculate the size of a transaction?

  • From: Stephane Faroult <sfaroult@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 16 Mar 2004 22:46:54 +0100

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

Other related posts: