We are trying to minimize elapased time for a batch proces (Java to
Oracle using PL/SQL stored procedures). This is a mainframe z890 with
zVM 5.2 and SLES 9.3 running Oracle 10.2 G. does anybody have any
suggestions on what to tweak.?

Whave I have done so far is changed Oracle to use DBWR slaves.
Before the change, with ASYNC IO's, my first step in a batch process
was taking 1:20 hour:minutes (no DBWR slaves). After switching to no
SYNC IO's and DBWR=4 slaves, the time went down to 1:12 hour:minutes.
The CPU went from about 70% down to about 68%. My I/O's per second
increased from about 800 to 1100. It stayed at about the same levels
for about the entire run of the first step.

Then, I tried to increase the DBWR to 6 slaves. The IO/second went up
to about 1,500 and the CPU jumped to 80%. This took place during the
insert/delete part of the processing (1/2 hour). When the select
(read) part of processing kicked in, the IO/sec dropped to less than
400 and the CPU to about 25% for about 1/2 hour. Then, CPU and I/O's
jump again (more inserts) for another 1/2 hour. The amount of time
went up again to 1:30 hour:minutes.

We are going to try to increase buffer size and try with ASYNC I/O's
to see what it does to us.

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting