Thanigaivasan, thank you for that info. What i was also looking for is how to add up the memory given to oracle. There is a limit of i think 1.75 gig of memory given to oracle no matter how many isntances you have. I think if you want to have more instances which demands more memory allocated to oracle then you have to create "memory windows". Do you know anything about that?

-Jigar