如何检查数据库参数配信赖息-上岗前准备（国外英文资料）.docVIP

怎么查看数据库参数配置信息-上岗前准备（国外英文资料） Preparation before the official start: how to view the database parameter configuration information Individual categories: oracle Make the performance test is actually a short tuning and testing process, rather than an end of the test is done so simple, intermediate analysis is critical to the process of tuning, contact oracle has for a long time, we use database is used oracle development, also has not do summary of oracle, here writing this article is also learning and summarize yourself. Here we go, the wrong thing to do, some of it to be taken from the books, some of the collected data, and some of our own hearts. Installation time note: select common USES in enterprise databases The difference between a dedicated server and a Shared server: in a dedicated connection, all the resources required for a connection are allocated in the PGA. The memory area is private for the specified connection, and the other: the path cannot be accessed. Dedicated one-to-one connection mode is used to connect, can quickly respond to users request, but, if the connection when too many users, due to each connection allocation of resources, therefore, the number of connections restricted by hardware is larger. In order to overcome this situation, the Oracle connection of connection sharing method is proposed, which USES a server process response of multiple users to connect, connect with special different have connection to create the PGA, sharing connections in the instance a start, is assigned a specified number of the server process, the users connection, in line, designated by the distributor to the server process, other process line. As soon as the users request is executed, the connection will be disconnected and the dispatcher will assign the idle server process to other excluded processes. A Shared connection of long transactions creates a serious queue in the Shared server process, resulting in a serious reduction in performance and a dedicated p