Post appears to be slow when doing an array insert (4299726)

When Post is doing an array insert, the # of "insert operations" posted as seen in the output of "show post detail" are incrementing very slowly and the Post appears to be slow.

General information.

Issue "show post detail" at different time intervals and look at the increments in the statistic "operations posted" to determine if the Post is really slow. In case of an array insert posted on target, if the "insert operations" is incrementing very slowly, it could very well be due to each array insert consisting of a large number of inserts. Thus the "insert operations" will show the # of such array inserts and each array insert may, in turn, consist of numerous regular inserts. These regular inserts form part of "operations posted" statistic. So if the "operations posted" figure is incrementing fast enough, then the Post is not slow. For example, in the following outputs of "show post detail" taken at 1 minute interval, the "insert operations" only incremented by 1 (reflecting one array insert) whereas the "operations posted" incremented by 25000 (reflecting regular insert) which tells us that Post is not slow:

sp_ctrl>show post detail

Target Status Posted Since
---------- --------------- ---------- ----------
o.SID Running 1054853 07-Jun-10

Last operation posted:
Redo log: 319744 Log offset: 1487910
INSERT MULTIPLE in "owner"."tablenameeeââ‚

Post state : Active
Activation Id : 50
Current transaction Id : 2
ID of blocking transaction : 0
Number of open transactions : 1
Number of messages read released : 66982401

Number of threads : 1

Operations posted : 1054853
Transactions posted : 0

Insert operations : 9803
Update operations : 0
Delete operations : 0

Key cache hit count : 0
SQL cache hit count : 99 %

sp_ctrl>show post detail

Target Status Posted Since
---------- --------------- ---------- ----------
o.SID Running 1054853 07-Jun-10

Last operation posted:
Redo log: 319744 Log offset: 1487910
INSERT MULTIPLE in " owner "." tablenameeeââ‚

Post state : Active
Activation Id : 50
Current transaction Id : 2
ID of blocking transaction : 0
Number of open transactions : 1
Number of messages read released : 66982401

Number of threads : 1

Operations posted : 1079853
Transactions posted : 0

Insert operations : 9804
Update operations : 0
Delete operations : 0

Key cache hit count : 0
SQL cache hit count : 99 %