Re: Any way to forace parallel query for another session?
- From: Kurt Franke <Kurt-Franke@xxxxxx>
- To: anysql@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Nov 2007 14:46:33 +0100
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';
regards
kf
> -----Ursprüngliche Nachricht-----
> Von: anysql@xxxxxxxxx
> Gesendet: 28.11.07 13:04:37
> An: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> Betreff: Any way to forace parallel query for another session?
> Hi:
>
>
>
> I want to speed up the exp or imp process, one way is to force parallel of
> the exp/imp session. We can use "ALTER SESSION FORCE PARALLEL QUERY PARALLEL
> n" for current session.
>
>
>
> Is their any interface to change another session of the force parallel query
> setting?
>
>
>
>
>
>
>
> Thanks.
>
>
>
> -- Fangxin Lou, Oracle DBA, from China
>
>
>
> Good tools make work easy and improve life quality
>
> -- http://www.dbatools.net
>
>
>
> Personal software, life, research and professional Oracle recovery service
>
> -- http://www.anysql.net/en
>
> -- http://www.anysql.net (Chinese)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
