PROFILING STORED PROCEDURES

An improved system and method for profiling elements of software applications facilitates identification and diagnosis of performance issues. Using aspect-oriented programming, additional code, referred to as an advice, is added at various steps in execution of a stored procedure. The additional code specifies additional action to be taken, such as capture of a stored procedure signature, parameters, and system time before and after execution. By adding the code at load time, the system of the present invention provides a mechanism by which the original procedure code as stored in the database and the application code calling the stored procedure can remain unchanged. Captured data is used in generating a profile of the stored procedure call.