Very slow response in 12c Multitenant

[gur]

Hi,

i am using PlSql-Developer with a 12c multitenant plugable database.
I think the response time (e.g. expand List of tables, query data of a table ...) is very slow.
I think everything which reads any kind of metadata or data dictionary acts very slow.
Sometimes I receive the message "Keine R

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[madmin]

Hi,

some of our user experience the same problem.
We also use 12c oracle database with the multitenant feature.

Occured problems are:
-Waiting time of up to 2 seconds to open a folder i.e. of a package in the Object Tree
-Auto-suggetion list if you start to write an object name in SQL Windows is slow (up to 3 seconds) or doesn't show up at all
-View Spec and Body of Objects (i.e. packages) sometimes takes up to 3 seconds

On occasion I will upload a debug.txt according to the previous response.

 

[gur]

There was no debug file in my usres "AppData\Roaming\PLSQL Developer" directory. Can you show me some other way to generate such a file.

Using this DebugSQL option took much more time to expand the table list in the object-tree.

... found it - not in "AppData\Roaming\PLSQL Developer" but in
the directory for the application.

 

[madmin]

I found the debug.txt likewise not in the anounced directory.

Further it was written to the installation folder. In my case:
"C:\Program Files (x86)\PLSQL Developer"

 

[anatoly_k]

Hi, Marco,

I have the same problem, i've sent the debug file to support@allroundautomations.com

 

[madmin]

Hi Marco,

is there anything new you can tell us?
Could you retrace our problems?

 

[gur]

Hi Marco,

the debug file was sent to support.
Can you tell me something new about our problem.
It's realy hard for our staff to work with PLSQL Developer
on oracle 12c.

 

[madmin]

Hi Marco,
how is it going? Can you please tell us something?

Greetings

 

[Gustavo]

Bump!