Home » RDBMS Server » Server Administration » unset session parameter during runtime of session (ORA 9.2.0.7)
unset session parameter during runtime of session [message #314354] Wed, 16 April 2008 07:46 Go to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi all,

I have a maybe easy question, but I don't know how to ....

We have a Job-Chain running against the Database. There are 30 jobs startet after the former job has finished. This means that the session is active all the time.
Now we needed to set a session parameter FORCE PARALLEL QUERY for 29 jobs to run fine. Only one job (no. 24) is running 10 times longer as without FORCE PARALLEL QUERY. Is there a way to unset this parameter within a function we call at the beginning of each job ? Is there something like
ALTER SESSION FORCE PARALLEL QUERY OFF;

I know this is not the right code (tested it) but which way to do this ? Disconnect is not possible.

Thanks
Uwe
Re: unset session parameter during runtime of session [message #314361 is a reply to message #314354] Wed, 16 April 2008 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER SESSION DISABLE PARALLEL QUERY;

Regards
Michel

Re: unset session parameter during runtime of session [message #314391 is a reply to message #314354] Wed, 16 April 2008 09:52 Go to previous message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Thanks Michel,

sometimes its good to read the Manual carefully ..... so I could find it, but some minute to late to supress this post Cool

regards
Uwe
Previous Topic: Need Steps to install oracle 9i in RHEL 4
Next Topic: How to investigate this ORA-01555
Goto Forum:
  


Current Time: Sat Dec 03 04:14:19 CST 2016

Total time taken to generate the page: 0.24664 seconds