![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
madgo
Joined: 22 Aug 2018 Posts: 13 Country: United States |
|
SA 10 Beta Issue - Oracle SQL Editor freezes all the time |
|
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.
![](https://s15.postimg.cc/i1zhk1cfr/2018-08-22_154800.png)
|
|
Wed Aug 22, 2018 3:55 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
madgo
Joined: 22 Aug 2018 Posts: 13 Country: United States |
|
|
|
It's OK if there is no intellisense for some time. but freezing? not acceptable.
|
|
Wed Aug 22, 2018 5:35 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
madgo
Joined: 22 Aug 2018 Posts: 13 Country: United States |
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
madgo
Joined: 22 Aug 2018 Posts: 13 Country: United States |
|
|
|
Yes. Even for formating.
|
|
Fri Aug 24, 2018 5:18 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
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 |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
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
|
|
|