Re: Snooping the SQL issued by a client app

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 27 Oct 2000 16:37:38 +0100
Message-ID: <8tc7gc$2pt$1@soap.pipex.net>

server side tracing may well be easiest in this situation ( or rewrite the app if that is possible to include a call to DBMS_SESSION.SET_SQL_TRACE Alternatively if the prog runs for long enough then you might have time to issue the call to dbms_system before your session hits the table.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"CUJimmy" <public_at_asd-group.com> wrote in message
news:8t96ll$9op$1_at_nnrp1.deja.com...


>

>

> But the program in question just runs, grabs some data (and writes it

> to disk files) and ends. It isnt interactive (sorry if I didnt make

> this clear). Hence I'm dubious about whether this would work. Wouldnt

> turning on the Server's tracing (by config files) be the only way to do

> it?

>

> Thanks again for your help.

>

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Fri Oct 27 2000 - 10:37:38 CDT