What would you do to fix this issue?

In a RAC environment, you see a steep increase for enq:HW – contention and gc current grant wait events.

What would you do to fix this issue?

In a RAC environment, you see a steep increase for enq:HW – contention and gc current grant wait events.

What would you do to fix this issue?

A.
Increase the cache size of sequences.

B.
Reduce the time of transactions by committing more often.

C.
Use larger uniform extent sizes for objects.

D.
Reduce the number of updates causing locks on tables accessed by multiple instances.



Leave a Reply 0

Your email address will not be published. Required fields are marked *