Re: Newbie trace question

In article <8ssrcq$7kv$1_at_bob.news.rcn.net>,   "Steve Long" <steven.long_at_erols.com> wrote:
> To enable the SQL trace facility for your session, issue the following
> statement:
>
> ALTER SESSION
> SET SQL_TRACE = TRUE;
>
> "CUJimmy" <public_at_asd-group.com> wrote in message
> news:8ss9e2$6lt$1_at_nnrp1.deja.com...
> > How can I turn on tracing on an Oracle 8i server so I can see the
 SQL
> > commands issued by a client program (the only one running) for
 which I
> > dont have the source?
> >
> > TIA
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

I doubt that the client program is invoking SQL*Plus therefore I suggest that the sql_trace init<SID>.ora parameter be set to 'TRUE' to enable tracing for the instance. You might also want to check the oracle_trace_collection_size and the max_dump_file_size parameters to ensure that you have them set large enough to capture the SQL.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.