Slow table access in Oracle 12c vs 11g

03-28-2016, 06:52 PM

I have an odd issue. Opening a table in Navicat is painfully slow in 12c vs.11g. A table that opens in 4 seconds in 11g opens in about 30 seconds in 12c with Navicat. There's nothing in the alert log or the AWR to indicate that there's any kind of issue. And when running the sql query directly within pl/sql that Navicat uses when opening a table it's fine as well. Also, opening the same tables in Toad and SQL Developer is equally as fast.