Re: Extracing Oracle SQL from network by Ethereal?

Hi!

Use v$sql rather than v$sqlarea, v$sql isn't so "heavy" on your server.

You can turn on sqlnet tracing with support level to get dump of sqlnet traffic. A parser is needed for extracting sql though. It will cause very big overhead, because all traffic has to be logged - you have 3 options to switch it on, either server side, client side or put a connection manager between server and client and do the logging there. That way your database server wont have the performance hit.

Tanel.

"ayeh" <ayeh18_at_hotmail.com> wrote in message news:6db5f19.0308250755.3dcbcca8_at_posting.google.com...
> Thanks for your replies... I've tried using the SGA and sqlarea, but
> that gets costly as I have to do a series of JOINs in order to find
> the last executed query, and I'd have to do this quite often so I
> won't be missing any queries as the library cache gets flushed (can
> either of these problems be bypassed?) And I can't use DBMS_LOGMNR
> for the reason that Sybrand mentioned.
>
> So my last resort is network sniffing, but seems like the packet
> format for different kinds of queries are different.
>
> Anyone else had a similar problem before?
>
> Thanks!
Received on Mon Aug 25 2003 - 13:11:43 CDT