Oracle How to trace an intermittent session the easy way
This video shows how to trace an intermittent connection such as a batch job connecting at random and executing series of queries. Two(2) triggers are used to start and stop the trace and the output file name is custom formatted with schema name and date stamp for easier identification. The trace file can then be processed using TKPROF tool to make it more human readable.
Use the sed command to extract all SQL in the trace file.
sed -n '/PARSING IN CURSOR/,/END OF STMT/{/PARSING IN CURSOR/b;/END OF STMT/b;p}' filename.trc
Watch video Oracle How to trace an intermittent session the easy way online without registration, duration hours minute second in high quality. This video was added by user Ken Kim 01 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 383 once and liked it 4 people.