payroll rollback performance issue

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 26 Apr 2005 18:00:56 +0300
Message-ID: <97b7fd2f0504260800700194b0@mail.gmail.com>

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."

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 26 2005 - 11:05:31 CDT