Re: I need log sql commands realtime

bikle_at_my-deja.com wrote in message <7unj2o$c1h$1_at_nnrp1.deja.com>...

>I'm looking for a way to view sql commands as they get sent
>to the kernel.

You need to use a tier architecture IMO. Slap in some middleware that serves as a kind of proxy or SQL-Gateway. Have the clients connecting to it. It in turns then connects to Oracle.

There is software such as this available. They are usually used for enforcing strict security, tracing/managing SQL, providing transperant access to homogenous and heterogenous databases, and even converting the SQL into more "efficient" SQL according to pre-defined database views/structures/whatever... Or that is what the marketing bluh says about these type of products. :-)

Another method would be to run a network sniffer and have it extract the SQL statements with IP addresses.

Of course, you can also run a polling process against V$ tables to get SQL statements out, but you will probably miss SQL statements that are very short in execution duration.

regards,
Billy Received on Fri Oct 22 1999 - 02:33:16 CDT