Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any way to forace parallel query for another session?

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

From: John Hallas <john.hallas_at_bjss.co.uk>
Date: Thu, 29 Nov 2007 14:37:18 -0000
Message-ID: <E02CB9B2777CF8459C86C49B48C48EC602B4DF10@exchange.bjss.co.uk>

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-l
Received on Thu Nov 29 2007 - 08:37:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US