New SQL Trace Data?
I found a new extended SQL trace line or class of lines this week while working on an Oracle Applications system. Many may have already run across this, but I hadn't and I found it very interesting. Apparently when Oracle Forms makes RPC calls now, they get logged in the extended SQL trace file. Here's the format of the lines:
RPC CALL:APPS.FND_TRACE.GET_TRACE_FILENAME;
RPC EXEC:c=70000,e=68146
So, I updated the AppsDBA Interval Resource Profiler to account for these new lines. Instead of adding the cpu time directly to cpu service though, I decided to create a new "event" called RPC EXEC and put the CPU time there. We'll see how this works, but for now I thought this was a pretty cool discovery.
RPC CALL:APPS.FND_TRACE.GET_TRACE_FILENAME;
RPC EXEC:c=70000,e=68146
So, I updated the AppsDBA Interval Resource Profiler to account for these new lines. Instead of adding the cpu time directly to cpu service though, I decided to create a new "event" called RPC EXEC and put the CPU time there. We'll see how this works, but for now I thought this was a pretty cool discovery.
0 Comments:
Post a Comment
<< Home