Re: How to calculate the size of a transaction?
- From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 18:09:56 -0400
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
-----------------------------------------------------------------
Other related posts:
