OraFAQ Forum: Performance Tuning » help plzz, oracle slow response

Home » RDBMS Server » Performance Tuning » help plzz, oracle slow response

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help plzz, oracle slow response [message #157671]

Fri, 03 February 2006 14:14

virtualmystic
Messages: 1
Registered: February 2006
Location: pakistan

Junior Member

hi,

i have oracle 9i running on solaris sparc u250 machine.
we are running oracle with our billing software that is built in java.
from past 1 month i am having problem that at times the billing software(basically RADIUS) stucks and receives response timeout from database in peak hours of RADIUS requests. i have checked and changed the RADIUS but no avail. now the problem can only be with oracle. i found a usefull script on net for finding out wait events in DB, it gave the following output.
System-wide Wait Analysis
for current wait events

Average
Event---------------------------------Total--Seconds--------Total------Wait
Name----------------------------------Waits--Waiting-----Timeouts-(in-secs)
---------------------------------------------------------------------------
db-file-sequential-read----------22,685,363----1,492------------0------.000
db-file-scattered-read------------6,129,723----2,694------------0------.000
direct-path-read-----------------1,665,895---49,180------------0------.030
direct-path-write----------------1,533,175--287,693------------0------.190
control-file-parallel-write----------85,023----1,300------------0------.020
log-file-parallel-write--------------72,692------794-------57,062------.010
db-file-parallel-write--------------36,696------776-------18,346------.020
control-file-sequential-read--------34,351--------3------------0------.000
log-file-sync---------------------29,035------480------------4------.020
enqueue-------------------------14,107---41,473-------13,489-----2.940
wakeup-time-manager------------8,281--246,899--------8,281----29.820
latch-free------------------------3,077-------55----------897------.020
buffer-busy-waits-----------------2,616-------22------------0------.010
LGWR-wait-for-redo-copy---------1,089--------0-----------14------.000
rdbms-ipc-reply-------------------48--------1------------0------.020
log-file-sequential-read------------34--------0------------0------.000
log-file-single-write----------------34--------1------------0------.010
log-file-switch-completion----------17--------2------------0------.090
process-startup--------------------10--------1------------0------.090
reliable-message--------------------2--------2------------1------.860
instance-state-change--------------2--------0------------0------.000
library-cache-pin--------------------2--------0------------0------.000
refresh-controlfile-command----------1--------0------------0------.020
control-file-heartbeat----------------1--------4------------1-----4.000

can anyone please look at these stats, and find out what is problematic and what should i do to sortout this problem.

regards,
asad

[Updated on: Fri, 03 February 2006 14:46] by Moderator

Report message to a moderator

Previous Topic:	Same query , Same database - Different performances ??
Next Topic:	bad view - slow reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:33:56 CDT 2024