payroll rollback performance issue
- From: The Human Fly <sjaffarhussain@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 18:00:56 +0300
Hello list,
We are facing performance issues with 'payroll rollback process'. Top
5 timed events are as follows:
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % To=
tal
Event Waits Time (s) Ela T=
ime
-------------------------------------------- ------------ ----------- -----=
---
db file scattered read 12,382 49 28=
.11
CPU time 44 25=
.46
db file sequential read 4,156 23 13=
.10
log file sync 786 20 11=
.62
control file parallel write 429 18 10=
.18
-------------------------------------------------------------
Server : Windows 2000 AS
Oracle 9i (9.2.0.3)
No. of CPUS : 4
Memory 8gb
Can some one shed some limelight on this issue?
--=20
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia
---------------------------------------------------------------------------=
-------------
"It is your atittude, not your aptitude that determins your altitude."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
