Re: SQL Trace
From: Sha <ssha53_at_singnet.com.sg>
Date: Sat, 23 Aug 2003 01:26:36 +0800
Message-ID: <bi5j2i$4nn$1_at_mawar.singnet.com.sg>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3f44f073$0$18494$ed9e5944_at_reading.news.pipex.net...
> > For System
> > ========
> > alter system set sql_trace=true
>
> as demonstrated elsewhere this is just wrong. Sorry.
>
>
> > set sql_trace=true in init.ora
> > set the 10046 event in init.ora
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Fri Aug 22 2003 - 19:26:36 CEST
Date: Sat, 23 Aug 2003 01:26:36 +0800
Message-ID: <bi5j2i$4nn$1_at_mawar.singnet.com.sg>
[Quoted] Hi again
[Quoted] Is this resource intensive ?
Thanks in advance.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3f462e2c$0$13638$ed9e5944_at_reading.news.pipex.net...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3f44f073$0$18494$ed9e5944_at_reading.news.pipex.net...
> > For System
> > ========
> > alter system set sql_trace=true
>
> as demonstrated elsewhere this is just wrong. Sorry.
>
>
> > set sql_trace=true in init.ora
> > set the 10046 event in init.ora
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Fri Aug 22 2003 - 19:26:36 CEST