Abstract: Disclosed are methods and apparatuses that implement automatic resizing of statement caches in response to cache metrics. One embodiment provides an approach for periodically calculating a session eligibility index for each session cache, wherein the session eligibility index indicates the priority level of the session cache for resizing, and selecting and resizing one or more cache sessions based at least in part on the session eligibility index.

Abstract: Disclosed are methods and apparatuses that implement automatic resizing of statement caches in response to cache metrics. One embodiment provides an approach for periodically calculating a session eligibility index for each session cache, wherein the session eligibility index indicates the priority level of the session cache for resizing, and selecting and resizing one or more cache sessions based at least in part on the session eligibility index.

Abstract: Various embodiments of the invention provide solutions to allow more sophisticated management of the relationship between a database and its clients (which can be, inter alia, end users, business applications, etc.). Merely by way of example, some embodiments can facilitate the management of work requests in a database, as well as the management of the quality-of-service in a database system. In some embodiments, an identification handle may be assigned to a database work request. A database management application can use the identification handle to identify the work request, as well, perhaps, as any related work requests. The identification handle may also identify the database (and/or an instance thereof) and/or a clustered database node, and the identification handle may be transmitted to a mid-tier application, e.g., to notify the mid-tier about the processing of the work request, changes in quality-of service, server availability, etc.

Abstract: Various embodiments of the invention provide solutions to allow more sophisticated management of the relationship between a database and its clients (which can be, inter alia, end users, business applications, etc.). Merely by way of example, some embodiments can facilitate the management of work requests in a database, as well as the management of the quality-of-service in a database system. In some embodiments, an identification handle may be assigned to a database work request. A database management application can use the identification handle to identify the work request, as well, perhaps, as any related work requests. The identification handle may also identify the database (and/or an instance thereof) and/or a clustered database node, and the identification handle may be transmitted to a mid-tier application, e.g., to notify the mid-tier about the processing of the work request, changes in quality-of service, server availability, etc.

Abstract: A method and apparatus allows a client to easily send multiple commands to a server. The client registers one or more tables with the method and apparatus of the present invention, which contain information with which to query the client if the client provides commands to be sent to a server. When the client sends a command intended for the server, the command and the tables are used to query the client. If the application responds affirmatively to the query, additional commands are generated for sending to the server. The method and apparatus assist in handling errors by deleting, either unconditionally or upon receipt of an instruction from the client, all pending commands related to the command causing the error and not generating additional such commands.

Abstract: A method and apparatus allows a client to easily send multiple commands to a server. The client registers one or more tables with the method and apparatus of the present invention, which contain information with which to query the client if the client provides commands to be sent to a server. When the client sends a command intended for the server, the command and the tables are used to query the client. If the application responds affirmatively to the query, additional commands are generated for sending to the server. The method and apparatus assist in handling errors by deleting, either unconditionally or upon receipt of an instruction from the client, all pending commands related to the command causing the error and not generating additional such commands.