Re: Is thjere a way to find all sql satements run by a session

I was succesful in writing a script using v$sql, v$sqltext, v$sql_plan to get all the statements in shared pool at that point in time which exceed some criterion (like elapsed_time > 0.5 mins). Now I can see entire statements (without getting chopped - spme of my statements are 500 lines long - were dynamical genearted) as well see sql based on elapshed time (somehing which statspack or OEM does not show).

Thanks a lot for various responses. Received on Tue Mar 28 2006 - 11:23:40 CST