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.

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.

It's OK if there is no intellisense for some time. but freezing? not acceptable.

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.

Okay. I left it over night. connection is still active. It still freezes at one point of time and becomes unusable.

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.

Yes. Even for formating.

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.