Page 1 of 1

Query executing is very slow!!!

Posted: Sun 03 May 2020 11:33
by farukhcasy2
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 ,

Re: Query executing is very slow!!!

Posted: Mon 04 May 2020 13:03
by alexa
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.