052-230(新增70题2018)

Oracle数据库连接负载均衡策略

最新推荐文章于 2025-12-01 18:34:47 发布

转载最新推荐文章于 2025-12-01 18:34:47 发布 · 92 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Babylon/p/8621782.html

文章标签：

#数据库

本文探讨了在Oracle Enterprise Manager 11g Database Control中设置连接字符串时，如何选择选项来平衡所有监听进程间的连接负载。通过随机选择监听器地址，实现客户端负载均衡，确保所有监听器能平均分担服务连接请求的负担。

Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD.

While setting up the connect string using Oracle Enterprise Manager 11g Database Control, which two options would you select to balance the connection load across all the listener processes? (Choose two.)

A. Use only the first address.

B. Try one address, selected at random.

C. Try each address, in order, until one succeeds.

D. Try each address, randomly, until one succeeds.

Answer: BD

Glossary

client load balancing

Load balancing, whereby if more than one listener services a single database, a client can randomly choose between the listeners for its connect requests. This randomization enables all listeners to share the burden of servicing incoming connect requests.

connect string

Information the user passes to a service to connect, such as user name, password, and connect identifier:

CONNECT username@net_service_name

connection load balancing

The method for balancing the number of active connections for the same service across the instances and dispatchers. Connection load balancing enables listeners to make routing decisions based on how many connections for each dispatcher and the load on the nodes.

转载于:https://www.cnblogs.com/Babylon/p/8621782.html