Query executing is very slow!!!

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
farukhcasy2
Posts: 4
Joined: Wed 08 Apr 2020 17:28

Query executing is very slow!!!

Post by farukhcasy2 » Sun 03 May 2020 11:33

Hi All,
I am executing the simple select statement. It is taking 2 sec in SQL developer but in dbForge, it is taking 50 sec.

Os version: Windows 10 64 bit
DB :
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Productionword counter VidMate Mobdro

CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Thanks ,
Last edited by farukhcasy2 on Thu 07 May 2020 12:27, edited 1 time in total.

alexa

Re: Query executing is very slow!!!

Post by alexa » Mon 04 May 2020 13:03

Could you please let us know what version of dbForge you are using and perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Reproduce this issue and send us the *.log file with the latest date from the folder:

Code: Select all

%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for Oracle\
Please also provide us the query you are executing.

You can send the reply straight to our support system at supportATdevartDOTcom.

Post Reply