Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kurt Franke
Sent: 29 November 2007 13:47
To: anysql_at_gmail.com; oracle-l_at_freelists.org
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-lReceived on Thu Nov 29 2007 - 08:37:18 CST
![]() |
![]() |