i have a oroblem while a stored proc running.
it just seas there and doing nothing for long but while i take snapshot for that appplication , it shows me row written and row selected going up.how do i capture sql statements run by this stored proc?
any help 'd be greatly appreciated...

You should find the information on the package name and section number currently executing, in your application snapshot

Sathyaram