Re: Tracing exp
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 14:42:40 -0700 (PDT)
--- Daniel Fink <Daniel.Fink@xxxxxxx> wrote:
> 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
>
while you're in the area of a logon trigger, how about
cranking up the db_file_multiblock_read_count, e.g.:
alter session set db_file_multiblock_read_count = 128;
to read 1 MB at a time, or whatever the max is that
your OS will allow.
I never bothered tracing exp, but it works well for
full table scans.
Pd
----------------------------------------------------------------
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:
