I have seen other shops with BizTalk have memory issues and it was due to missing indexes. Check to see if you are doing unnessary table scans that...

Mark,

First of all you should not create your clustered index by the fields in the where clause. You should create non-clustered indexes on the fields in the where clause....

As I understand your problem, you are trying to develop on a 64 bit machine after installing only the 64 bit version or Oracle. If that is correct then...