Patent ID: 8656367

Claim:
A computer-implemented method for profiling a stored procedure, comprising: in a processor, receiving an instruction to execute a call preparation function to prepare a call to invoke a stored procedure; in the processor, inserting first additional code to the call preparation function operable to capture a call signature of the stored procedure; in the processor, receiving an instruction to execute a parameter setting function to set a parameter for the stored procedure; in the processor, inserting second additional code to the parameter setting function operable to capture the parameter for the stored procedure; in the processor, receiving an instruction to execute a call executing function operable to invoke the stored procedure with the parameter for the stored procedure; in the processor, inserting third additional code to the call executing function operable to capture at least one data item concerning the stored procedure; in the processor, executing the call preparation function, the parameter setting function, and the call executing function, including executing the first, the second, and the third additional code to capture the call signature, the parameter, and the at least one data item, respectively, concerning the stored procedure; in a storage device, storing the captured call signature, the captured parameter, and the captured at least one data item; in the processor, determining an association between the captured call signature, the captured parameter, and the captured at least one data item; in the processor, generating a report profiling the stored procedure based on the captured call signature, the captured parameter, and the captured at least one data item; and in an output device, outputting the generated report.