• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Eliminate Queries against SYS.ALL_SYNONYMS with PowerBuilder 12.5 / Oracle applications

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Eliminate Queries against SYS.ALL_SYNONYMS with PowerBuilder 12.5 / Oracle applications

  1. How-to
0
Votes
Undo
  1. Richard Bianco
    Richard Bianco
  2. PowerBuilder
  3. Wednesday, 17 July 2024 17:31 PM UTC

We have a PowerBuilder 12.5 application that runs against Oracle 12 and Oracle 19c.

DBA's have noticed excessive queries against SYS.ALL_SYNONYMS.  I understand that these queries have been a part of PowerBuilder for some time, and it seems they occur when SyntaxFromSQL is used. 

 

Is there any way to prevent the queries from happening? 

Is this behavior the same in most recent versions of PowerBuilder?

 

  1. Oracle
  2. PowerBuilder
Local PB copy connected to server DB
Could not connect PowerBuilder windows app to SQL ...
Responses (1)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 17 July 2024 18:59 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Richard -

I found this post from September 2020 that appears to relate to your issue:

    https://community.appeon.com/index.php/qna/q-a/too-many-call-to-oracle-all-synonyms-view

Perhaps the information in it will help you.

Best regards, John

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.