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@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)


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

Other related posts: