How to calculate the size of a transaction?

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Tue, 16 Mar 2004 15:37:27 -0600
Message-ID: <A42F529F25C23349B01EEA3170220C560185EF52@MSPM1BMSGM02.ent.core.medtronic.com>

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

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Mar 16 2004 - 15:33:56 CST