Index Contention
RDBMS Version: 10.2.0.4
Operating System and Version : Solaris 10
Error Number (if applicable) :
Product (i.e. SQL*Loader, Import, etc.) : Enterprise Edition (with RAC)
Product Version : 10.2.0.4 RAC
Index Contention
Hi,
My name is Andrew. Currently I am looking at an index contention issue. This happens on a local index of a range-partitioned table.
This table is used for tracking our application response time. You could imagine how frequent records would be inserted into, for a busy system.
The partitioning key of this table is on a column called app_service_start_datetime (a TIMESTAMP field). There is an index on this column and this is the one having contention issue, due to massive amount of records inserted into the table. Yes, we are using 3 nodes RAC as well.
Operating System and Version : Solaris 10
Error Number (if applicable) :
Product (i.e. SQL*Loader, Import, etc.) : Enterprise Edition (with RAC)
Product Version : 10.2.0.4 RAC
Index Contention
Hi,
My name is Andrew. Currently I am looking at an index contention issue. This happens on a local index of a range-partitioned table.
This table is used for tracking our application response time. You could imagine how frequent records would be inserted into, for a busy system.
The partitioning key of this table is on a column called app_service_start_datetime (a TIMESTAMP field). There is an index on this column and this is the one having contention issue, due to massive amount of records inserted into the table. Yes, we are using 3 nodes RAC as well.
0