In order to simplify the steps of enabling, stopping the trace on Oracle sessions and make the output trace data readable, I've written two scripts, start_tracing.sh will let you enable tracing on a specific session, and stop_tracing.sh to stop tracing the session and provide the original trace file along with another readable version of the trace file using TKPROF utility.
Download links:
start_tracing.sh
https://www.dropbox.com/s/dkhjteqckcuykqd/start_tracing.sh?dl=0
stop_tracing.sh
https://www.dropbox.com/s/41krahxx8m67uyg/stop_tracing.sh?dl=0
Those scripts are part of the DBA bundle which equipped with many of easy to use scripts that simplify day to day database administration tasks:
http://dba-tips.blogspot.ae/2014/02/oracle-database-administration-scripts.html
DISCLAIMER: THIS SCRIPT IS DISTRIBUTED IN THE HOPE THAT IT WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. IT IS PROVIDED "AS IS".
start_tracing.sh
stop_tracing.sh
Download links:
start_tracing.sh
https://www.dropbox.com/s/dkhjteqckcuykqd/start_tracing.sh?dl=0
stop_tracing.sh
https://www.dropbox.com/s/41krahxx8m67uyg/stop_tracing.sh?dl=0
Those scripts are part of the DBA bundle which equipped with many of easy to use scripts that simplify day to day database administration tasks:
http://dba-tips.blogspot.ae/2014/02/oracle-database-administration-scripts.html
DISCLAIMER: THIS SCRIPT IS DISTRIBUTED IN THE HOPE THAT IT WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. IT IS PROVIDED "AS IS".
start_tracing.sh
stop_tracing.sh
scripts not available on provided link
ReplyDeleteDear Md. Tanweer,
ReplyDeleteThanks a lot for your comment.
I've updated the links to a good working ones.
Thanks again and sorry for any inconvenience caused.
Mahmmoud ADEL