SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA 10 Beta Issue - Oracle SQL Editor freezes all the time

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA 10 Beta Issue - Oracle SQL Editor freezes all the time
Author Message
madgo



Joined: 22 Aug 2018
Posts: 13
Country: United States

Post SA 10 Beta Issue - Oracle SQL Editor freezes all the time Reply with quote
I tried to work with oracle database using SA SQL Editor 64 bit and it freezes all the time. i am not able to use it at all.


Wed Aug 22, 2018 3:55 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Please wait, give it some time. If you try to query system objects especially using cascading views, the very first time it may take a long time to load SQL Assistant's cache. Some people said in their version of Oracle it took almost 5 minutes to load until they managed to run stats collection for Oracle system tables.
Wed Aug 22, 2018 4:19 pm View user's profile Send private message
madgo



Joined: 22 Aug 2018
Posts: 13
Country: United States

Post Reply with quote
It's OK if there is no intellisense for some time. but freezing? not acceptable.
Wed Aug 22, 2018 5:35 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
It's not freezing, it's stuck waiting for an Oracle database query to return results. There are several system views in Oracle 12 R1 which are very slow when they are queried with broad terms (not for a single table), that's the root cause of the wait. If you run stats analysis collection on Oracle system tables, it would help a lot. Or if upgrade to a more recent Oracle version, you won't see this issue too.
Wed Aug 22, 2018 6:36 pm View user's profile Send private message
madgo



Joined: 22 Aug 2018
Posts: 13
Country: United States

Post Reply with quote
Okay. I left it over night. connection is still active. It still freezes at one point of time and becomes unusable.
Thu Aug 23, 2018 10:11 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
That's not good.
Does it always happen after typing WHERE or after FROM too?

FYI. After first WHERE is trying to read all_tab_columns view to cache column definitions of all tables and view in the database.
Thu Aug 23, 2018 4:17 pm View user's profile Send private message
madgo



Joined: 22 Aug 2018
Posts: 13
Country: United States

Post Reply with quote
Yes. Even for formating.
Fri Aug 24, 2018 5:18 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Do you have a different Oracle server to try the same?

I'm pretty sure the issue is caused by very slow query execution performance. If you're interested I can show how to reproduce that issue using the queries executed by SQL Assistant.
I would recommend running statistics collection on system tables, that should help oracle choose different query execution plans when it knows number of records in all system tables and their data distribution.
Sat Aug 25, 2018 3:38 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.