Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> payroll rollback performance issue

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US