Rebuild of indexes slow in RAC
Hi,
Rebuild of indexes took 3 times more execution time on RAC Production environment compared to a non-rac non-production environment.
The AWR report showing "enq: TM - contention" as the top wait event.
Rebuild was done with Applications services and database listener kept down during the Production maintenance window.
Enabled level 12 trace the wait even gc cr multi block request is seen in all instances.
param db_file_multiblock_read_count is set to 119.
is there is any way to tune RAC parameters for better performance.
Any suggestions/advice will be really helpful.
Thanks.
Rebuild of indexes took 3 times more execution time on RAC Production environment compared to a non-rac non-production environment.
The AWR report showing "enq: TM - contention" as the top wait event.
Rebuild was done with Applications services and database listener kept down during the Production maintenance window.
Enabled level 12 trace the wait even gc cr multi block request is seen in all instances.
param db_file_multiblock_read_count is set to 119.
is there is any way to tune RAC parameters for better performance.
Any suggestions/advice will be really helpful.
Thanks.
0