Re: How to capture SQL

"Randy Harris" <randy_at_SpamFree.com> wrote in message news:<TrxUc.2712$ZC7.249_at_newssvr19.news.prodigy.com>...
> Is there a simple means of capturing an SQL statement sent from an
> application to an Oracle 9i server (on the server end)? I've been looking
> through the documentation, not sure if this should be done with trace, or
> auditing or if there is some way to enable SQL logging, or dump the redo log
> or something else.

If it is something that runs for a while: go into OEM 9.2 top sessions and select the session you want. The logon time is probably the best way to relate what session you want if your app doesn't show usernames unambiguously. Drill down to the explain plan. Click on the report icon. Show management what a brilliant performance analysis and documentation expert you are.

jg

--
@home.com is bogus.
"It means 'friend'" - Cheech
http://www.guardian.co.uk/online/news/0,12597,1286066,00.html