1. A method for optimizing a query plan reuse in a database server system, comprising: providing at least one global cache storage that stores a single instance of the query plan for the prepared SQL statement and a private cache storage to a plurality of client connections, wherein the single instance of the query plan in the at least one global cache is shared by each client connection providing instructions to execute the prepared SQL statement and the private cache storage includes information that determines whether the single instance of the query plan exists in the at least one global cache; and coordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures (LWPs) and query plans for prepared SQL statements across the plurality of client connections while avoiding a spinlock access for executing the prepared SQL statements, wherein coordinating the utilization further comprises determining, using the information in the private cache storage, whether the single instance of the query plan is stored in the at least one global cache and wherein the spinlock access is avoided when the plurality of client connections reuse the single instance of the query plan.