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_at_gmail.com> 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."
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 26 2005 - 11:07:42 CDT
