Oracle SID VS Service Name

chncaesar發表於2013-10-09
Oracle
https://forums.oracle.com/thread/540986?start=0&tstart=0
Discussions in this post explain the concepts of sid and service well. 
Here're some important notes:

1. With Oracle Resource Manager, it becomes interesting to associate a program, user, session or application with a service. It is then possible to manage the resource utilitization on a per-service basis.

2. In RAC, service is key to failover. Instead of connecting to a specific instance, you're connected to a surviving and/or idle instance.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/638844/viewspace-774022/，如需轉載，請註明出處，否則將追究法律責任。

相關文章