hi all,
In my oracle stage and under the arraysize what should be the normal opted length.
some say we have to put arraysize as 1
and some say it to be 1000.
Does it have any performance on the arraysize
oracle stage array size
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Fri Sep 22, 2006 10:59 pm
- Location: India
Hi,
Array size determines the number of rows to be read from the database or number of rows write to the database at a single time.
For example, for reading data from database, if it is 1, then for each and every row it will read the data from the database.
If the array size is 10 for writing, then after every 10 rows it will write the data to the database.
Array size may increase the performance. But if the array size is too large, it may use the large amount of client memory and sometimes it will go for out of memory.
Array size determines the number of rows to be read from the database or number of rows write to the database at a single time.
For example, for reading data from database, if it is 1, then for each and every row it will read the data from the database.
If the array size is 10 for writing, then after every 10 rows it will write the data to the database.
Array size may increase the performance. But if the array size is too large, it may use the large amount of client memory and sometimes it will go for out of memory.
Regards,
Balaji.
Balaji.
Balaji is right. It is not easy to find the right size. As he said a good rule of thumb is to balance between both size when reading and writing. The one has to be same or factor of the other. 5-10 or 10-5 is okay, 10-12 or 12-10 is suboptimal.
Same is true with commit size.
If there would be an optimal size for all constallations the datastage devellopers would have set it to that size.
Same is true with commit size.
If there would be an optimal size for all constallations the datastage devellopers would have set it to that size.
Wolfgang Hürter
Amsterdam
Amsterdam
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Only by trial and measurement. There are no magic formulae. Array size is not really about optimizing select/load; it's about optimizing traffic between DataStage and Oracle.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.