Bug 162

Slow retrieval in database painter using Oracle 16 October, 2020

Kyle Bengtson
10 July, 2017
Product: PowerBuilder Category: Database
Version: 2017 Build:
Classification: Sybase (legacy) bug Publishing: Public
Priority: P3
Status: Closed Reason: RESOLVED
Ken Guo @Appeon 16 October, 2020
#6
Hi Kyle,

OK. We will close this ticket! 
If you have any further question, please open a new ticket.

Regards,
Ken
Kyle Bengtson 16 October, 2020
#5
Sorry, I don't remember since it was over 3 years ago.
Ken Guo @Appeon 16 October, 2020
#4
Hi Kyle,

I am glad that you have solved the issue.
Could you please elaborate on how you solve it?


Regards,
Ken
Kyle Bengtson 15 October, 2020
#3
This is no longer an issue, you can close this ticket.
Ken Guo @Appeon 15 October, 2020
#2
Hi Kyle,

Do you still encounter this issue? If this issue still exists, please let me know:
1. What is your Oracle version number? Is this problem if the database is upgraded to Oracle 18c/19c?
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
Zhao Kai @Appeon 10 July, 2017
#1
Hi,

Thanks for providing this information. We reproduced it on our end and will do further research to figure it out. We will keep you posted about the progress.

PB 12.6 has same issue, and it seems that this issue related to DBMS.

Regards,
ZhaoKai
Kyle Bengtson 10 July, 2017
*Phenomenon:
Slow db retrieval

*Reproduce Steps:
1) Connect to DB
2) Click on tables folder
3) Expand a table


Remark:
Also, some select statements take much longer than they should in the database painter and some datawindows take longer than they should to display when you look at the SQL through Design->Datasource.
OS:
All
Platform:
All
Database Type:
Oracle
Database Version:
12c