My requirement: I have 75 SQL's in the App engine, and I need to log the time for Every SQL into a table. PS_MESSAGE_LOG table is not helping us. because we run the App engine through Autosys. which will not generate Process Instance number. SO if you can help me that would be great
Sorry for the delay, I just came from my vacation.
It is possible to enable Application Engine trace from Command line
Add SQL trace parameters in Autosys and you should able to get the trace file
Or Enable Application Engine Trace from Process Scheduler and execute it from Process scheduler to get the trace file
Let me know for any questions