I comment, every time that PowerBuilder makes a connection to Oracle Database for development issues, this not only performs the connection also brings dictionary information from the database and scheme to which you are connecting so you can have information ready in memory when a query is made for the creation of a datawindows or some other object or statement sql that has to do with the database.

If you have this problem at run time, it may be due to your network, or your database is in the cloud and has some kind of restriction to perform the validation more efficiently, it also verifies the activation of data comprehension in the client.

Regards

Juan Alejandro Lam

Hi Scott,

This seems to be a common issue with Oracle 12c. You may find more info here: https://asktom.oracle.com/pls/apex/asktom.search?tag=query-taking-very-long

Regards,

Thank you so much for taking the time to reply.

However it only occurs with the 12c client. So when I use older clients to older versions of Oracle on the same computer/network I can connect in under 2 secs. Now with the latest client and latest version of Oracle it takes upwards of 18 secs. I know oracle added some new authentication stuff in 12c/18c but not sure if this is the issue causing the slowness.

Please note that this issue started with Oracle 12c and is common across all PowerBuilder developers and all development environments.

I have not seen this to be an issue when connecting to the Oracle 12c database in runtime.

This was NOT an issue in Oracle 11g or 10c. In Oracle 12c, though, the connection times take longer, and the first access to any table takes a noticeable amount of time, anywhere from 4 - 30 seconds depending on the size of the table. It is as if on the first connection to any table, the table scans itself.

There is no known fix for this.


Olan

Thanks for the info!!