Home / Q&A / Oracle DB enforce parallelism
You can translate the question and the replies:

Oracle DB enforce parallelism

Hi Team, We are facing issues while fetching data from Oracle DB, which is taking longer time than usual. When checking with DB team, they suggested to use below(with parallel option) while running a select command. I tried to run the same manually and the data fetch is pretty quick. Can you please let me know, how to enforce such while creatingh Base Views or JDBC connection strings or is there is any other way to enforce parallelism? SELECT /*+ PARALLEL(4) */ * from oracle_db_name where col=some_value; --> took 2 minute to complete for ~250 rows SELECT * from oracle_db_name where col=some_value ; --> running forever
Oracle DB connection Issue JDBC parallel performance
user
28-01-2020 14:32:36 -0500

1 Answer

Hi, When creating base views from an Oracle data source, you could choose the "Create from query" option and specify the Parallel query that uses the syntax of Oracle database. On executing this base view, the query provided in the definition of base view would be executed in the underlying data source. You could refer to the article [Using the Create Base View From Query Option]( https://community.denodo.com/kb/view/document/Using%20the%20Create%20Base%20View%20From%20Query%20Option?category=Data+Sources) for more information. Hope this helps!
Denodo Team
31-01-2020 01:53:34 -0500
You must sign in to add an answer. If you do not have an account, you can register here