Oracle - Why create several service_name in service_names parameter?

by Danilo Neto   Last Updated August 13, 2019 23:06 PM

SERVICE_NAMES specifies one or more names by which clients can connect to the instance. The instance registers its service names with the listener. When a client requests a service, the listener determines which instances offer the requested service and routes the client to the appropriate instance.

What is the reason for I modify the parameter service_names like this

Service_names = 'service_one','service_two'

Rather than

Service_names = 'service_one'

Answers 1

Because in the same database you have multiple applications, multiple workloads,... and services help to: - identify sessions when troubleshooting performance issue - manage resources for those with higher or lower priority - balance between several nodes - offload some read-only workloads to a standby database ...

August 14, 2019 08:04 AM

Related Questions

Updated August 15, 2019 13:06 PM

Updated June 17, 2017 14:06 PM

Updated January 08, 2018 11:06 AM

Updated October 08, 2017 19:06 PM