Parameter for setting up parallel processing in Oracle Thin JDBC Connect String

0
votes

i would like to know if there is a connect param, that i can use in JDBC Thin Oracle Connection URL, to tell the Oracle DB that i want to use Parallelism in processing the queries.

The Application, that should be use this parameter generates Statements during runtime and fires them against the Database, so i can't update or optimize them. In nearly every query i run in timeouts and the User on the other side gets an error message.

If i fire the generated Statements and send them with /* parallel */ Hint with the SQL Developer, i have a much better performance.

Maybe someone has a hint, that i can achive a better performance.

1
oracleperformanceparallel-processing
I seriously doubt there is such a parameter. - OldProgrammer

1 Answers

2
votes

You could use a logon trigger to force parallel execution of all query statements in the session for which parallelization is possible. This would override any default parallelism property on individual objects.

CREATE OR REPLACE TRIGGER USER1.LOGON_TRG
AFTER LOGON ON SCHEMA
BEGIN
    EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL QUERY 4';
END;
/