摘要 |
<p>The present invention relates to a system for recompiling a plan cache in a database. More particularly, a system for recompiling a plan cache in a database includes a cache memory configured to store a plan; a recompile determining unit configured to determine whether to recompile the plan corresponding to the received query; and a recompile processing unit configured to receive the recompiled plan from a client based on the determination of the recompile determining unit and to store the recompiled plan in the cache memory, wherein the determination of the recompile processing unit is performed on the basis of the number of pages allocated to a file where the plan is used.</p> |