dear all,
user report aplikasi jalane letoy tenan euy.....
ora9ir2.0.1
redhat7.1
ram 2.5gb
sga 1.5gb
buffer cache 512mb
large pool 608mb
shared pool 304mb
i/o raid 5 scsi
shared server, user +- 25, tapi session bisa >100
statspack:
Snap Id Snap Time Sessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 1 17-Apr-06 09:34:30 68 24.6
End Snap: 2 17-Apr-06 10:09:48 76 26.1
Elapsed: 35.30 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 512M Std Block Size: 8K
Shared Pool Size: 304M Log Buffer: 512K
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
control file parallel write 731 0 15 20 4.5
log file sync 150 0 1 9 0.9
db file sequential read 166 0 1 4 1.0
process startup 2 0 0 31 0.0
latch free 6 2 0 7 0.0
log buffer space 1 0 0 21 0.0
SQL*Net more data to client 553 0 0 0 3.4
control file sequential read 261 0 0 0 1.6
SQL*Net break/reset to clien 13 0 0 1 0.1
log file parallel write 607 607 0 0 3.7
db file parallel write 268 134 0 0 1.7
db file single write 16 0 0 0 0.1
direct path read 68 0 0 0 0.4
LGWR wait for redo copy 8 0 0 0 0.0
direct path write 16 0 0 0 0.1
enqueue 1 0 0 0 0.0
virtual circuit status 40,609 13 2,166 53 250.7
wakeup time manager 69 67 1,988 28814 0.4
SQL*Net message from client 40,697 0 1,228 30 251.2
SQL*Net message to client 40,700 0 0 0 251.2
-------------------------------------------------------------
pak bowo & pak tomi or yg laennya....suggesti nya dong....
my thinking :
1. musti di buatin disk berbeda utk tujuan berbeda ?
disk utk datafile, log file, ctl file musti dipisahin? apa perlu async io?
tapi rh71 support gak ya async io?
2. buatin dedicated server ?
3. any other clues?
regards
--ujang
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
