Database - RAC/Scalability (MOSC)

MOSC Banner

_lm_tickets

edited Jan 22, 2025 12:29AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered ✓

Oracle 19c on RHEL Linux

The parameter _lm_tickets sets "GES messaging tickets". By default, the value is 1000. I find that on any 2-node RAC database, tckt_limit of gv$ges_traffic_controller is indeed 1000. But on all our 4-node RAC's, tckt_limit is lowered to 333, and so tckt_avail sometimes goes down to quite low. I suspect Oracle's algorithm is that _lm_tickets does not directly set the number of tickets for each RAC node. Instead, the ticket limit is set to 1000/(n-1) where n is node count. If anybody has a 3-node RAC, could you check gv$ges_traffic_controller and see if tckt_limit is 500? Anyway, if you have

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center