Bug 1103

syntaxfromsql taking a long time in Oracle 12c compared to Oracle 11g 15 October, 2020

Regin Ravindran
10 May, 2018
Product: PowerBuilder Category: DataWindow
Version: 2017 Build:
Classification: Sybase (legacy) bug Publishing: Public
Priority: P2
Status: Scheduling Reason:
Ken Guo @Appeon 15 October, 2020
#5
Hi Regin,

Do you still encounter this issue? If this issue still exists, please let me know:
1. What is your Oracle version number?
2. How many schemes are there in the database? Try adding some more schemes. If there are more schemes, will the performance be slower?
3. If you execute the following 3 SQLs in Oracle DB, how long will each of them take:

SELECT OWNER, TABLE_NAME,'TABLE' TABLE_TYPE FROM SYS.ALL_TABLES
WHERE OWNER <>'SYS' AND DROPPED ='NO'
UNION SELECT OWNER, VIEW_NAME,'VIEW' TABLE_TYPE FROM SYS.ALL_VIEWS WHERE OWNER <>'SYS'

SELECT * FROM "PUBLIC"."ALL_ANNOTATION_TEXT_METADATA"

SELECT S.OWNER, S.SYNONYM_NAME
FROM SYS.ALL_SYNONYMS S, SYS.ALL_OBJECTS O
WHERE (S.TABLE_OWNER <>'SYS' AND O.OBJECT_NAME = S.TABLE_NAME
AND O.OWNER = S.TABLE_OWNER AND O.OBJECT_TYPE IN ('VIEW','TABLE'))
UNION SELECT Q.OWNER, Q.SYNONYM_NAME FROM SYS.ALL_SYNONYMS Q
WHERE (NVL(Q.TABLE_OWNER,'?') <>'SYS' AND Q.DB_LINK IS NOT NULL)

Regards,
Ken
Mark Lee @Appeon 08 November, 2018
#4
Hi Regin,

We are sorry to inform you that this bug is not fixed yet.
We suggest that you upgrade to PB 2017 R3 1858 and try it out.
This version is more stable than PB 2017 R2 and fixed many bugs and includes many new features.
https://www.appeon.com/support/documents/appeon_online_help/pb2017r3/whats_new/index.html
 
Of course, we will continue to follow up this issue and will update you when there is any progress.

Regards,
Mark Lee
Regin Ravindran 08 November, 2018
#3
Can I get a status on this pls?
Has it been fixed and do we need to upgrade PB to resolve this?
Mark Lee @Appeon 11 May, 2018
#2
Hi Regin,

Thanks for reporting this problem! 
We will escalate this problem to our development team for further analysis. 
We will need some time to figure it out, and we will get back to you if any progress we would make.

 Based on our initial analysis, this might be related to the features added in Oracle 12c itself and we’d suggest to use O10 Oracle 10 or ODBC to connect to Oracle 12c database to work it around.

Regards,
Mark Lee
Govinda Lopez @Appeon 10 May, 2018
#1
Hi Regin,

I will transfer it to our Engineering team for further analysis. We will keep you posted of the results here.


Regards,
Regin Ravindran 10 May, 2018
Issue:
We are having an issue when a datawindow is being built dynamically in our production database which is on Oracle 12c. The select statement used to build the datawindow is a join of a view and 2 tables. 
The user is seeing some time lapse when trying to open the window(that is when the dynamic datawindow is built using syntaxfromsql). 
This application when run against a database that is on Oracle 11g creates the datawindow fast and displays it immediately. Pls let me know if there is any setting that can be changed in Oracle or PowerBuilder to make this faster.
Pls let me know if you need any additional information.
OS:
Windows Server 2008 R2
Platform:
64-bit
Database Type:
Oracle
Database Version:
12c