Re: capture SQL

It is an enormous performance hit, but you can turn on SQL tracing and then all sql will be sent to trace files which you can then edit and extract anything you want. However, if your system is already slow you really only want to do this during slack periods and then only for short amounts of time because the output is voluminous and you will see you wio percentage be very high while you have tracing turned on.

Ken

marina.daniels_at_cs.tas.gov.au wrote:

> I have a 3rd party pc application and it communicates with Oracle 8.0.5
> on my unix box via the Oracle drivers. (The drivers on my pc are
> installed from version 7.3.3 oracle as the 3rd party application
> requires this :-(
>
> Does anybody know how I can capture the sql commands that are being sent
> from my pc to the unix box?
>
> The application is running slow and I want to run the sql command
> directly on the unix box to see if it runs faster there to see if the
> slowness is due to the way I have oracle configured, or whether there is
> some problem with the pc side of things.
>
> If anybody takes pity on me, could you please reply to:
> marina.daniels_at_cs.tas.gov.au
>
> Thanks
> Marina
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 07:17:15 CDT