Dedicated vs. Oracle Database Tips by Donald Burleson. The Oracle multithreaded server MTS, later renamed "shared servers" was developed way-back in the days of Oracle7 when RAM was very expensive and RAM region sizes were severely limited by bit technology. Oracle shared servers are also inappropriate for ERP packages that spawn and hold database connections within the application server layer. Bobby Durrett notes that shared servers make sense in rare cases where you have a farm of web servers connecting to your Oracle database, a case where connection pooling makes sense. We have had some outages on the weekend caused by a sudden burst in web server generated database activity. In the past the CPU load would spike and log file sync commit waits would be 20 times slower and we would have to bounce the database and web servers to recover.
Understanding Database Services
What is an Oracle database link
This chapter describes how to configure the advanced features of Oracle Net Services, including advanced connect data parameters, load balancing , failover , and connections to non-database services. A database service can be accessed by several routes and protocol addresses. You configure which routes to use by setting the list of protocol addresses. You configure the order addresses are used by specifying the address parameters. This section contains the following topics:. A database service may be accessed by more than one network route, or protocol address. In the following example, sales. To add a network protocol address to an existing network service name or database service, use one of the following procedures:. The following procedure describes how to add a network protocol to an existing network service name or database service using Oracle Enterprise Manager Cloud Control:. Select Local Naming or Directory Naming from the Administer list, and then select the Oracle home for the directory server or the location of the local configuration files.
An Oracle database is represented to clients as a service ; that is, the database performs work on behalf of clients. A database can have one or more services associated with it. Figure shows two databases, each with its own database service for intranet clients. One service, sales. Another service, finance.
Parent topic: Understanding Oracle Net Services. A database has at least one instance. The memory and processes of an instance efficiently manage the associated database's data and serve the database users. Figure shows two database instances, sales and finance , associated with their respective databases and service names. Instances are identified by an instance name , such as sales and finance in this example. The instance name defaults to the Oracle system identifier SID of the database instance. Some hardware architectures allow multiple computers to share access to data, software, or peripheral devices. Oracle Real Application Clusters Oracle RAC can take advantage of such architecture by running multiple instances on different computers that share a single physical database.