Clover process has double execution time since 11gr2

CloverDX Platform
1

Hi guys,

First , I know nothing about Clover, I have to support an application that use it for some process (loading data from a .add file and process it)

Second, I’m french, sorry for the bad english.

we changed database version from Oracle 11gr1 to 11gr2 last summer and since then , the execution time for our ‘‘load’’ process have doubled.

I didn’t change anycode or the graph at all since then.

My question is : Does the database update have something to do with that execution time augmentation ?

I don’t know how I could change the graph to make the performance better.

PS : I know you must need the graph or the execution log. Tell me what you need to tell me and I’ll provide it.

Thanks in advance, Elliot

2

Sorry for double post.

I can’t find any edit button on my previous post anyway…

A simplier question may result as an anwser.

Right now , I see in my log this :

[java] [Clover] starting WatchDog thread …
[java] [WatchDog] Thread started.
[java] [WatchDog] Running on 16 CPU(s) max available memory for JVM 3005703 kB

I’m starting clover via an ant build.xml file like this :

My question : There is actually 100gig of free ram on this server … How can I make clover start with more ram via ant ?

Thanks,

3

Hi Elliot,

If you want to raise memory assigned to clover, you can use the following element after the element.

But it is not sure that more memory will help you in this case. R2 could have changed something in the Oracle application itself, having negative influence on the overall performance of your query. Or the update could have restored some settings you set in R1. Did you try to leave CloverETL out for a while and test your queries directly? Did you notice any performance changes when running the queries directly?

One thing you could try is downloading the new ojdbc6.jar driver released with R2. If the direct queries work fine, incompatible driver could be another cause of the issue.

http://www.oracle.com/technetwork/datab … 90769.html

Regards,

4

Hi,

I tried to raise the memory but like you said it didn’t change the performance at all.

Actually the query is very simple and it took less than a second executing it.

I’ll try the new driver.

Thanks,