2. The index is based on a sequence number (Monotonically increasing index)- Did you test on sequence + cache ?
Interconnectivity is the key to hardware scalability, which greatly depend on high bandwidth and low latency.By the way...
Online transaction processing (OLTP) is characterized by short transactions that cannot be further broken down and, therefore, no speedup can be achieved. However, by deploying greater amounts of resources, a larger volume of transactions can be supported without compromising the response.
For heavy OLTP applications , if we can not implement Application functional partitioning or Horizontal data partitioning across instances,about OLTP, RAC can not help about response time , but help to reserve many sessions...
RAC is not an option. (PLease correct me if I am wrong).
We have tried sequence cache 10000, However, I do not understand how that is going to help in the "right most index block " contention .Oracle Sequences and Index Contention
Can you please through some light into this /