Code Assistant hangs in Exadata ver. 12C

[Ron E]

Many of our users still have ver. 9, and we have previously been running 11G on AIX boxes. While testing our new Exadata 12C version, they are reporting that when they enter

SELECT *
FROM tablename F
WHERE F.

and let the code assistant list the columns, the program seems to hang, sometimes for hours. I have ver. 11.0.4 and haven't noticed this (yet).

Quest sent a note for TOAD, which had the same issue, to change the default hints assigned to the tables V$LOCK (RULE), DBA_ALL_TABLES (RULE), and DBA_OBJECTS (CHOOSE). That seemed to fix the problem for TOAD.

But we don't see any options for changing those hints in PL/SQL Dev. Is there any setting like that available, or is the best answer to upgrade everybody to 11, assuming the same thing doesn't start happening with that release?

Thanks,

Ron

 

[Marco Kalter]

I think it will be necessary to upgrade to version 11. It uses a different method to resolve object names.

 

[Ron E]

That's what I sort of thought.

Thanks for the prompt reply (as always).

Ron