1. Scott Paxman
  2. PowerBuilder
  3. Wednesday, 14 November 2018 21:35 PM UTC

I am using PB 2017 R3 and connecting to oracle  via  a 32 bit 12c client. Everything seems to be working except that it takes an abnormally long time to establish the connection (18 secs). Is there some setting I can use to speed up the connection process. I can connect with sqlplus in under one sec so I do not see a network/oracle issue here.

Scott Paxman Accepted Answer Pending Moderation
  1. Friday, 30 November 2018 15:36 PM UTC
  2. PowerBuilder
  3. # 1

Thanks for the info!!

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 29 November 2018 18:39 PM UTC
  2. PowerBuilder
  3. # 2

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

Comment
There are no comments made yet.
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Thursday, 29 November 2018 17:27 PM UTC
  2. PowerBuilder
  3. # 3

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,

Comment
There are no comments made yet.
Scott Paxman Accepted Answer Pending Moderation
  1. Thursday, 29 November 2018 16:30 PM UTC
  2. PowerBuilder
  3. # 4

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.

 

Comment
There are no comments made yet.
Juan Alejandro Lam López Accepted Answer Pending Moderation
  1. Thursday, 29 November 2018 16:15 PM UTC
  2. PowerBuilder
  3. # 5

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

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.