SERVICE specifies service names & dispatchers register with listeners - Managing Oracle Database Processes

Discussion

• Nirja Shah   -Posted on 23 Sep 15
  - SERVICE (SER or SERV) - Specify the service names the dispatchers register with the listeners.
  - If no values are specified, then service names specified with the SERVICE_NAMES initialization parameter are used.
  
  - CONNECTIONS (CON or CONN) - Specify the maximum number of network connections to allow for each dispatcher.
  - The default is operating system specific.
  - For example, 1024 is the default for Solaris Operating System and Windows NT.
  
  - LISTENER (LIS or LIST) - Specify an alias name for the listeners with which the PMON process registers dispatcher information.
  - Set the alias to a name which is resolved through a naming method.
  - The LISTENER attribute overrides the LOCAL_LISTENER and REMOTE_LISTENER initialization parameters.
  - The LISTENER attribute only needs to be specified if its value is different from the values specified by the LOCAL_LISTENER and REMOTE_LISTENER parameters.
  - Note that the LOCAL_LISTENER parameter has a default value of TCP/IP, port 1521.
  
  - MULTIPLEX (MUL or MULT) - Use to enable the Oracle Connection Manager session multiplexing feature.
  - If 1, ON, YES, TRUE, or BOTH is specified, then session multiplexing is enabled for both incoming and outgoing network sessions.
  - If IN is specified, then session multiplexing is enabled for incoming network sessions from clients.
  - If OUT is specified, then session multiplexing is enabled for outgoing network sessions.
  - If 0, NO, OFF, or FALSE is specified, then session multiplexing is disabled for both incoming and outgoing network connections.

➨ Post your comment / Share knowledge