First of all you need to find SID,SERIAL of that session from v$session for that you can run simple query
Thanks for the response. Could you please let me know what all are the parameters should i trace in prespective of Report job performance. If possible will you be able to provide me the query for tracing it.
It will generate file in you UDUMP directory then you can use TKPOOF utility
tkprof <file>.trc alligned.txt explain=system/<password>
DK2010 wrote:I disagree. The OP is asking about overall database performance while a batch process is running. Tracing a single session is not useful in this case.
You can trace the session using the Event Parameter and get the report O/P using Tkprof