In order to get the best performance I have below questions.
1. In theory how many instances can be added in RAC (11g)?
2. Practically how many instances can give best performance?
Note: I think after certain number of instances the performance will be flat, means no more performance benefit after a certain level.
Is there any already proved method with statistics to decide the same?
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.