Monday, May 14, 2012

FORMULA for Determining the number of dispatcher in oracle database.


Number of dispatchers =
CEIL ( max. concurrent sessions / connections for each dispatcher )


For example, assume a system that can support 970 connections for each process, and
that has:
■ A maximum of 4000 sessions concurrently connected through TCP/IP and
■ A maximum of 2,500 sessions concurrently connected through TCP/IP with SSL
The DISPATCHERS attribute for TCP/IP should be set to a minimum of five
dispatchers (4000 / 970), and for TCP/IP with SSL three dispatchers (2500 / 970:
DISPATCHERS='(PROT=tcp)(DISP=5)', '(PROT-tcps)(DISP=3)'

No comments:

Post a Comment