So is it only updating Oracle tables that is slow, not reading? If so READBUFF isn't going to help. In my experience there is no magic bullet to speeding up database writes, you just have to experiment with different techniques to see what works best. We update SQL Server databases a lot and do get good performance typically using table appends. The INSERTBUFF and DBCOMMIT options are helpful for this.
You would be best to post the complete SAS log of an Oracle database update program that is slow so we can get a better idea of what you are doing.
... View more