RE: Tracing exp

From: David Kurtz <info_at_go-faster.co.uk>
Date: Wed, 28 Jul 2004 00:17:54 +0100
Message-ID: <CKEAJBMGFEOCDBFILPJDAEOOEEAA.info@go-faster.co.uk>

I've done this application session, but not with export. It also depends on the operating system.
v$session.program is not populated on all flavours of Unix when the connection is made via a listener.

regards

David Kurtz
Go-Faster Consultancy Ltd.

tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk

mailto:david.kurtz_at_go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daniel Fink
> Sent: 27 July 2004 22:05
> To: oracle-l_at_freelists.org
> Subject: Re: Tracing exp
>
>
> Untested, unproven, just popped into the head of a known-deranged
> Scotch hound...
>
> How about a logon trigger that checks v$session.program and sets
> the trace if the program is 'exp'?
>
> Regards,
> Daniel Fink
>
> Schauss, Peter wrote:
> > We have a third party application which does some replication by doing
> > a series of exports (Oracle exp) from the source database and using
> > the generated files to import into the target database. Since
> the performance
> > of this process is becoming a concern, I would like to put a
> 10046 trace on one
> > of these exports to see if there is anything that we can do to make the
> > underlying SQL more efficient.
> >
> > Is there a parameter in the exp command which I could use to
> trigger a 10046
> > trace?
> >
> > The userid under which these exp's run is used for other
> purposes, so I would
> > prefer not to use a login trigger for this purpose.
> >
> > Thanks,
> > Peter Schauss
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 27 2004 - 18:14:56 CDT