Inventors:
Ekkehard Rohwedder - Newark CA, US
Quan Wang - Portland CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 7/00
G06F 17/00
US Classification:
707648, 707649, 707672, 707682, 709224, 719328
Abstract:
Techniques for end-to-end tracing of database operations in source code for database applications are provided. Source code on the client side is instrumented to measure time spent on selected database operation statements (e. g. , queries). The selected database operation statements can be uniquely tagged or identified. Tracing is enabled on the database application on the server side so that a log is produced, where the log includes performance (e. g. , time spent) information on database operation statements that are executed. The performance information in the log is correlated to the selected database operation statements so that, among other things, the time spent on the client side and the time spent on the server side can be presented for analysis.