Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: get rollback info for process

Daniel Fink

2006-05-30

Replies:

Doug,

Do you mean which segments the process wrote undo information, read undo information or both?

Regards,
Daniel Fink

Doug Gernaat <dag@its.msstate.edu> wrote:
we have a ProC program that runs for about 90mins.
after its completion, i would like to be able to identify
which rollback segments it used. a trace/tkprof didn't
help me(maybe i overlooked). statspak? any ideas?

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



©2008 dba.5341.com - Jax Systems, LLC, U.S.A.