Re: How to identify the SQL being rolled back?

Sure, I don't see why not. But if that was the case (i.e. no other txns), then what would be the fun of it? You'd be talking about a benchmark or a PC, not a real production system... :-)

on 8/26/05 1:59 PM, Allen, Brandon at Brandon.Allen_at_OneNeck.com wrote:

> That's what I was afraid of, thanks. I thought of one approach to find the
> objects being rolled back - would it make sense to check which segment(s) in
> v$segment_statistics are getting the most "db block changes" and "physical
> writes", if it is known that there are no other transactions currently
> performing updates?

--
http://www.freelists.org/webpage/oracle-l