RE: Any way to forace parallel query for another session?

I must admit that I was stumped by the original question as I was unsure
of whether he was using exp or expdp and what he was trying to achieve

The first has no parallel option and the only way of speeding it up is
to parellise the number of tables being exported by running a number of
exports, all working on different tables

Expdp (Data Pump) has a parallel option which controls the number of
worker processes

I am guessing that the OP was trying to get the query part of the export
process to use parallel query. However I am not sure that would work as
the data has to be written to the dmp file in a serial manner

John

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kurt Franke
Sent: 29 November 2007 13:47
To: anysql@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Any way to forace parallel query for another session?


Hi,

you may build a logon trigger on database, check there if program in
v$session
is exp or imp and if found then call the alter session with native
dynamic sql:
EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY PARALLEL n';




BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW.
Registered in England with company number 2777575.
http://www.bjss.co.uk

--
http://www.freelists.org/webpage/oracle-l

Other related posts: