Issue with "Oracle Provider for OLE DB"

Discuss RoboTask here
Post Reply
userXXX
Posts: 58
Joined: Wed Jun 11, 2014 8:45 am

Issue with "Oracle Provider for OLE DB"

Post by userXXX »

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.
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: Issue with "Oracle Provider for OLE DB"

Post by Oleg »

What about previous version of OLE DB provider for Oracle (10 or 11)?
Not oracle client, only DB provider.
Oleg Yershov
userXXX
Posts: 58
Joined: Wed Jun 11, 2014 8:45 am

Re: Issue with "Oracle Provider for OLE DB"

Post by userXXX »

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.
Post Reply