Thanks all replied my question agaion. We solved this problem by
modifying the application, batch 100 commit into one commit with the
most used dml statement. Now the log file sync drop from 75% of total
time wait(just before put the modified app online) and now it is 38% of
total time wait , and now there is about 6-9 commits/second. The most
frequenctly used service(from tuxedo) drop from 0.27S to 0.00??S(less
than 0.01S). It was very successful:)
--
an oracle fan,
an oracle beginner
Posted via dBforums
http://dbforums.com
Received on Tue Jul 23 2002 - 02:26:24 CDT
