RoboTask forum

Hello,

we are using a Oracle 12c database, Robotask is running on a VM with Oracle client 12.xxx and Oracle Provider for OLE DB 12.xxx.

A SQL with some CREATE and MERGE statesments takes 3-4min when starting from a local PC within Oracle SQL Developer and there are no issues with CPU ressources.
Running the same thing within Robotask (one "SQL Query" action calls a Oracle procedure which delimits the SQL statement into parts and executes it) takes 2-4hrs and uses lots of CPU ressources.

Before we had the same problem with using Oracle client 11.xxx and Oracle Provider for OLE DB 11.xxx. So, it's not about the client version.

Do anybody knows, if there are some limitations when using this provider?
Can someone recommend an alternative? It's really urgent, I need a quick solution.

Thanks.

What about previous version of OLE DB provider for Oracle (10 or 11)?
Not oracle client, only DB provider.

The problem wasn't caused by the driver but by "/*+ parallel */ clauses" used to improve performance while filling tables. With this clauses we got an issue with blockings causing long wait times. After dropping this clauses performance is better now.