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';

regards

kf

> -----Ursprüngliche Nachricht-----
> Von: anysql_at_gmail.com
> Gesendet: 28.11.07 13:04:37
> An: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> 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)

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