It also describes the how to manage and use the query cache, a feature that enables the Oracle BI Server to save the results of a query in cache files and then reuse those results later when a similar query is requested. This chapter describes ways to improve Oracle Business Intelligence query performance, including a performance tuning overview and information about monitoring system metrics. Samples for performance monitoring have been included with this version of ODBC.14/44 7 Managing Performance Tuning and Query Caching You must specify your own monitoring parameters. For more information, see Driver-Aware Connection Pooling.
This counter was added in Windows 8, for drivers that manage connections in the connection pool. The number of pools active, including active and removed pools. These are live connections that are available for use. The current number of free connections available in the pool. The number of connections in the pool that are currently in use. When the application releases or disconnects, the connection is placed back in the pool. The number of disconnects per second issued by the applications. ODBC Soft Disconnection Counter per Second Depending on the load on your server, it is not uncommon for this to show 40-60 soft connections per second. This counter indicates whether pooling is working. The number of connections satisfied by the pool per second-in other words, connections from that pool that were handed to users. This value will increase from zero when you stop all clients on the system and the connections start to time out. These are actual connections to the server that are being released by connection pooling. The number of hard disconnects per second issued to the server. When the connections to the server have been established, they will be used and placed in the pool for reuse.
This is the normal situation when connection pooling is working. After a few seconds, it will drop to zero. The first time your environment carries a heavy load, this counter will go up very quickly. The number of actual connections per second that are made to the server. These statistics can be customized by the developer to include items such as the following: Counter Performance monitoring tracks connection performance by recording a variety of statistics.
Double-click a driver name to set the connection time-out period.įor more information about connection pooling, see ODBC Connection Pooling. It is accomplished by setting the default value of CPTimeout during the driver's setup program. This selective per-driver enabling allows a system administrator to enable connection pooling for just the drivers that can support it. Double-click a driver name to set the connection time-out period.Īt the driver level, connection pooling is enabled by the CPTimeout registry value. You can use the Connection Pooling tab of the ODBC Data Source Administrator dialog box to enable and disable performance monitoring. Connection pooling enables an application to use a connection from a pool of connections that do not need to be reestablished for each use.