Re: Tracing exp
- From: Daniel Fink <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 15:04:59 -0600
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
