Re: SQL Trace
Date: Fri, 22 Aug 2003 12:22:54 -0700
Message-ID: <3F466D8D.F38001DE_at_exxesolutions.com>
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)Received on Fri Aug 22 2003 - 21:22:54 CEST