Doug, Do you mean which segments the process wrote undo information, read undo information or both? Regards, Daniel Fink Doug Gernaat <dag@xxxxxxxxxxxxxxx> 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- -- //www.freelists.org/webpage/oracle-l