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