Serially reusable execution memory

Claim 3

The method of claim 1, further comprising the step of finding an execution memory area pool associated with said program unit from a plurality of execution memory area pools; wherein said execution memory pool contains said previously allocated and configured execution memory area.

Claim 4

The method of claim 2, wherein the step of finding an execution memory area pool associated with said program unit from a plurality of execution memory area pools includes the steps of: storing a reference to said execution memory area pool associated with said program unit in a hash table; hashing a string describing said program unit into a hash key; and looking up said reference in said hash table with said hash table key.

Claim 5

The method of claim 1, further comprising the step of deallocating an old execution memory area in said execution memory area pool, wherein said old execution memory area is a least recently used, within a prescribed amount of time, execution memory area of all execution memory areas within said execution memory area pool.

Claim 6

The method of claim 1, wherein: said execution memory area pool is a free list of previously allocated and configured execution memory areas; the step of inspecting an execution memory area pool to find a previously allocated and configured execution memory area includes the step of checking for a first previously allocated and configured execution memory area of said free list; the step of establishing said previously allocated and configured execution memory area as said execution memory area to execute said program unit includes the step of moving said first pooled execution memory area from said free list to an in-use list of execution memory areas; the step of establishing said new execution memory area as said execution memory area to execute said program unit includes the step of adding said new execution memory area to said in-use list; and the step of adding said work area to said execution memory area pool includes the step of moving said execution memory area from said in-use list to said free list.

Claim 7

The method of claim 5, further comprising the steps of: obtaining a mutually exclusive lock before inspecting the execution memory area pool; releasing the mutually exclusive lock after establishing said previously allocated and configured execution memory area as said execution memory area to execute said program unit; before allocating the new execution memory area, performing the steps of: creating an empty slot in said in-use list and releasing the mutually exclusive lock after creating the empty slot; obtaining the mutually exclusive lock before adding said execution memory area to said execution memory area pool; releasing the mutually exclusive lock after adding said execution memory area to said execution memory area pool; and wherein the step of adding said new execution memory area to said in-use list includes the step of adding said new execution memory area to the empty slot of said in-use list.

Claim 8

The method of claim 1, wherein the step of allocating a new execution memory area includes the step of allocating a new execution memory area from a shared memory.

Claim 9

The method of claim 1, wherein the step of executing said program unit using said execution memory area includes the step of executing a query using a work area.

Claim 10

The method of claim 1, wherein the step of executing said program unit using said execution memory area includes the step of executing a package using a package frame.

Claim 11

A computer readable medium having stored thereon sequences of instructions for allocating an execution memory area to execute a program unit, said sequences of instructions including instructions for performing the steps of: in response to receiving a command to execute said program unit, inspecting an execution memory area pool to find a previously allocated and configured execution memory area that is currently unused, wherein said previously allocated and configured execution memory area includes a plurality of memory chunks and pointers initialized to the memory chunks; wherein said execution memory area pool contains execution memory areas that are available to a plurality of users in a database system; if a previously allocated and configured execution memory area is found in said execution memory area pool, then establishing said previously allocated and configured execution memory area as said execution memory area to execute said program unit; if a previously allocated and configured execution memory area is not found in said execution memory area pool, then performing the steps of: allocating a new execution memory area by allocating a plurality of new memory chunks, configuring said new execution memory area by initializing pointers to the memory chunks, and establishing said new execution memory area as said execution memory area to execute said program unit; executing said program unit using said execution memory area as configured; and if said execution memory area is not already in said execution memory area pool then adding said execution memory area to said execution memory area pool.

Claim 12

A computer readable medium having stored thereon sequences of instructions for allocating an execution memory area to execute a program unit, said sequences of instructions including instructions for performing the steps of: in response to receiving a command to execute said program unit, inspecting an execution memory area pool to find a previously allocated and configured execution memory area that is currently unused, wherein said previously allocated and configured execution memory area includes a plurality of memory chunks and pointers initialized to the memory chunks; wherein said execution memory area pool contains execution memory areas that are available to a plurality of users in a database system; if a previously allocated and configured execution memory area is found in said execution memory area pool, then establishing said previously allocated and configured execution memory area as said execution memory area to execute said program unit; if a previously allocated and configured execution memory area is not found in said execution memory area pool, then performing the steps of: allocating a new execution memory area by allocating a plurality of new memory chunks, configuring said new execution memory area by initializing pointers to the memory chunks, and establishing said new execution memory area as said execution memory area to execute said program unit; executing said program unit using said execution memory area as configured; and if said execution memory area is not already in said execution memory area pool then adding said execution memory area to said execution memory area pool.

Claim 13

The computer readable medium of claim 10, wherein said sequence of instructions further includes instructions for performing the step of finding an execution memory area pool associated with said program unit from a plurality of execution memory area pools; wherein said execution memory pool contains said previously allocated and configured execution memory area.

Claim 14

The computer readable medium of claim 11, wherein the step of finding an execution memory area pool associated with said program unit from a plurality of execution memory area pools includes the steps of: storing a reference to said execution memory area pool associated with said program unit in a hash table; hashing a string describing said program unit into a hash key; and looking up said reference in said hash table with said hash key.

Claim 15

The computer readable medium of claim 10, further comprising instructions for performing the step of deallocating an old execution memory area in said execution memory area pool, wherein said old execution memory area is a least recently used, within a prescribed amount of time, execution memory area of all execution memory areas within said execution memory area pool.

Claim 16

The computer readable medium of claim 10, wherein: said execution memory area pool is a free list of previously allocated and configured execution memory areas; the step of inspecting an execution memory area pool to find a previously allocated and configured execution memory area includes the step of checking for a first previously allocated and configured execution memory area of said free list; the step of establishing said previously allocated and configured execution memory area as said execution memory area to execute said program unit includes the step of moving said first pooled execution memory area from said free list to an in-use list of execution memory areas; the step of establishing said new execution memory area as said execution memory area to execute said program unit includes the step of adding said new execution memory area to said in-use list; and the step of adding said execution memory area to said execution memory area pool includes the step of moving said execution memory area from said in-use list to said free list.

Claim 17

The computer readable medium of claim 14, further comprising instructions for performing the steps of: obtaining a mutually exclusive lock before inspecting the execution memory area pool; releasing the mutually exclusive lock after establishing said previously allocated and configured execution memory area as said execution memory area to execute said program unit; before allocating the new execution memory area, performing the steps of: creating an empty slot in said in-use list and releasing the mutually exclusive lock after creating the empty slot; obtaining the mutually exclusive lock before adding said execution memory area to said execution memory area pool; releasing the mutually exclusive lock after adding said execution memory area to said execution memory area pool; and wherein the step of adding said new execution memory area to said in-use list includes the step of adding said new execution memory area to the empty slot of said in-use list.

Claim 18

The computer readable medium of claim 10, wherein the step of allocating a new execution memory area includes the step of allocating a new execution memory area from a shared memory.

Claim 19

The computer readable medium of claim 10, wherein the step of executing said program unit using said execution memory area includes the step of executing a query using a work area.

Claim 20

The computer readable medium of claim 10, wherein the step of executing said program unit using said execution memory area includes the step of executing a package using a package frame.

Claim 23

The method of claim 19 further comprising the step of inspecting an execution memory area pool to find said execution memory area, wherein said execution memory area pool contains execution memory areas that are available to a plurality of users of said database system.

Claim 24

The method of claim 20 further comprising the step of adding said execution memory area to said execution memory area pool.