| unset session parameter during runtime of session [message #314354] |
Wed, 16 April 2008 07:46  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
