Re: get rollback info for process

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: Tue, 30 May 2006 09:11:57 -0700 (PDT)
Message-ID: <20060530161157.25122.qmail@web37214.mail.mud.yahoo.com>

Doug,

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

Regards,
Daniel Fink

Doug Gernaat <dag_at_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

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 30 2006 - 11:11:57 CDT