Re: Extracing Oracle SQL from network by Ethereal?

From: Maximus <asdfasdasd_at_eqeqweqwe.com>
Date: Fri, 22 Aug 2003 22:05:20 GMT
Message-ID: <Asw1b.810625$3C2.18402340@news3.calgary.shaw.ca>

"ayeh" <ayeh18_at_hotmail.com> wrote in message news:6db5f19.0308221346.19909af8_at_posting.google.com...
> Hi forum,
>
> I'm using Ethereal to capture Oracle's network packets for analysis.
> Is there a way for Ethereal to only pull out the SQL statements from
> the packets? If not, is there another tool that does it?
>
> I've tried using snoop, and it gives me the entire package content as
> well. However, I'm unable to extract the SQL from it because I don't
> know the proper format for Oracle's TNS packets.
>
> Thanks in advance!

Specifications for Oracle's network protocol isn't published, AFAIK You're out of luck there, really all you can do is look for ASCII text in captured packets.

If you are using 9i, you can view/access all SQL statements sent to the server via the redo log miner packages DBMS_LOGMNR and DBMS_LOGMNR_D. Received on Fri Aug 22 2003 - 17:05:20 CDT