RE: How to calculate the size of a transaction?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 16:03:51 -0600
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
-----------------------------------------------------------------
Other related posts:
