Re: Oracle-Networking Question...

A transaction starts with the first DML statement and ends with a commit or rollback statement. DDL statements do an implicit commit before execution and a implicit commit or rollback after execution. And stored procedures can manage their own transactions.

Determining transaction boundaries from packets is not simple and depending on your application, may be impossible.

You can get commit and rollback counters using the following (8.1.7).

select name, value
from v$sysstat
where name = 'user commits' or name = 'user rollbacks'

These are cumulative counters. You would need to take two samples and divide by your sample period to get a transaction rate.

"And" <anand_at_sionintl.com> wrote in message news:5e52e21b.0301240959.1ff8d6c1_at_posting.google.com...
> For a project, we are trying to find throughput. We are interested in
> knowing if there is anything in the packet that is sent back (client -
> server) that would indicate that the transaction has ended, and the
> next packet belongs to a new transaction? This is important for us to
> figure out through sniffer etc to find the transactions.
>
> Thanks
Received on Sat Jan 25 2003 - 20:33:34 CET