| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
> -----------------------------------------------------------------
-- 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 - 16:03:13 CDT
 |
 |