Oracle and Servoy

Classic Servoy
1

Hi,

Is there anyone who is using Oracle database (10.2.0.4) and Servoy 4.1.1.

I am just starting to prepare the migration of 3.5.9 to 4.1.1.

I notice that starting up and checking out is very slow ( checkout of sample crm takes 5 to 10 minutes)
after starting up the cpu stays on 100% for several minutes, Servoy and Oracle are the consumers.

Are there any special settings, configurations or … in the combination of Servoy 4.1.1 and Oracle 10.2.0.4.

I run 3.5.9 on the same computer on the same database and that runs just fine.

Regards,

Hans

2

Try to specify a schema in the server editor for Oracle servers. Put there the Oracle user name.
Don’t know if this is the case for you or not, but not specifying a schema might end up showing thousands of Oracle system tables/views that you do not need to work with, and all those are read in the background to check columns and so on.

3

Ok, will try that and let you know.

Thanks,

Hans

4

Hi Andrei,

That was the issue. I specfified a schema for each database server and now it is fast again !!

I tried this in 3.5 and i thought id did not work.

Now I discovered that it has to be uppercase !!

Thanks again.

Regards,

Hans