1.

What Is The Significance Of Latches With Respect To Performance Tuning?

Answer»
  • An Oracle process must acquire relevant latch in order to get resource allocated.
  • A latch is REQUIRED for a very short amount of time to ensure that the resource is allocated.

WHENEVER there is a contention for latch, it indicates that there is a performance ISSUE, which may be due to EITHER of the two following REASONS:

    • Lack of availability of resource.
    • Poor application programming resulting in high number of requests for resource.

Whenever there is a contention for latch, it indicates that there is a performance issue, which may be due to either of the two following reasons:


Discussion

No Comment Found

Related InterviewSolutions