Comparison of execution time

[Hide]

Hello,

Does anyone know why PL/SQL Developer has slower response comparing with Oracle SQL*plus.

Even execution of simple comand like SQLESC using command window has much slower than SQL*plus.
Server is Oracle 9.2.0.6.0.
Client is Oracle 9.2.0.1.0.

I've tested multiple client access but the result was same.

thanks in advance.

 

[Marco Kalter]

For SQL*Plus commands such as describe, performance may differ, since they are implemented differently. For example: the Command Window als shows the column comments when describing a table.

For SQL commands and PL/SQL commands, there should not be any difference.

 

[Hide]

Thank you.

I understand. There are nothing i can do for the differences.

regards.