Re: tracing SQL

Hi,

if you want to trace any process, either your own or others then Oracle provides a trace mechanism. You can set different levels to capture data such as bind value and wait events. I have a paper that details a large amount of ways to set trace for your own session or for another session and also how to set the different levels. The paper can be found here: http://www.petefinnigan.com/ramblings/how_to_set_trace.htm

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.