Re: Extracing Oracle SQL from network by Ethereal?

Sybrand Bakker wrote:

> "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

Not to mention a large number of possible unlogged transactions such as those involving global temporary tables.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)