look in v$transaction and extrapolate how long it's going to take by monitoring USED_UREC. not much else you can do that i know of. On 4/26/05, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: > Hello list, >=20 > We are facing performance issues with 'payroll rollback process'. Top > 5 timed events are as follows: > Top 5 Timed Events > ~~~~~~~~~~~~~~~~~~ % = To=3D > tal > Event Waits Time (s) Ela= T=3D > ime > -------------------------------------------- ------------ ----------- ---= --=3D > --- > db file scattered read 12,382 49 = 28=3D > .11 > CPU time 44 = 25=3D > .46 > db file sequential read 4,156 23 = 13=3D > .10 > log file sync 786 20 = 11=3D > .62 > control file parallel write 429 18 = 10=3D > .18 > ------------------------------------------------------------- >=20 > Server : Windows 2000 AS > Oracle 9i (9.2.0.3) > No. of CPUS : 4 > Memory 8gb >=20 > Can some one shed some limelight on this issue? > --=3D20 > Best Regards, > Jaffar, OCP DBA > Banque Saudi Fransi > Saudi Arabia > -------------------------------------------------------------------------= --=3D > ------------- > "It is your atittude, not your aptitude that determins your altitude." > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l