Re: Extracing Oracle SQL from network by Ethereal?

"Maximus" <asdfasdasd_at_eqeqweqwe.com> wrote in message news:Asw1b.810625$3C2.18402340_at_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.
>
>

Incorrect. Does redolog apply to SELECT. No, of course not! Logmnr only captures insert, update and delete and was available in *8i*

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address