Re: SQL Trace

Sha wrote:

> Hi again
>
> 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
> >
> >

Not something I'd run 7x24 on a production database with high activity. But neither would I call it a major issue.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)