PLSD Crash (v.7.0.3)

[KCinAustin]

My install of PLSD crashes frequently with no warning or info in the plsqldev.log file. It's not anything I've been able to reproduce with consistency, but it seems that many times it will crash when I click on the result grid. I have tried uninstalling and reinstalling which did not fix it. Any recommendations? Is this a known issue?

thx

PL/SQL Developer
Version 7.0.3.1123 (MBCS)
- Unlimited user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 523,636 kB (140,376 available)
Paging file : 1,276,284 kB (782,012 available)
Virtual memory : 2,097,024 kB (2,022,004 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\myname\default.ini

Plug-Ins
*LBC Recall Named SQL (C:\Program Files\PLSQL Developer\PlugIns\LBCNamedSQL.dll)
*StartupOptions 1.1 (C:\Program Files\PLSQL Developer\PlugIns\StartupOptions.dll)
(* is Active)
Homes
ORACLEHOME (C:\ORACLE)
DLLs
C:\ORACLE\bin\oci.dll
TNS File
C:\ORACLE\Network\Admin\tnsnames.ora
Using
Home: ORACLEHOME
DLL: C:\ORACLE\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.8.0
Character size: 3 byte(s)

 

[Marco Kalter]

I notice that you are using Oracle 9.2.0.8. This version has a bug that can indeed cause crashe.

Can you modify the PL/SQL Developer shortcut(s) and add the NoQueryOptimize parameter? For example:

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

This should work around the 9.2.0.8 bug. Let me know of this helps.

 

[klaus_jesper]

Hi,

same problem here with Oracle 9.2.0.8.

Are there any side effects when using the NoQueryOptimize parameter? What type of optimization is disabled?

I'm asking because I need the same behaviour (performance) for all statements in pl/sql-developer AND in my java-application. Otherwise I can't use pl/sql-developer for development.

Thanks
Klaus

 

[Marco Kalter]

You will not notice the difference. It affects the performance of small queries that are executed repeatedly with the exact same SQL text and variable types.

This setting is applied by default in the upcoming 7.1 release.

 

[KCinAustin]

Thanks Marco. It's been close to a week now and no crashes.

 

[girishbhandary]

Hi Marco,

I experience exactly the same issue as member #6787 here - same versions of Oracle server and PL/SQL Dev.

I tried the "NoQueryOptimize" solution, but the crashes persist.

Any other suggestions ? Also, how do I generate a PLSQLDEV.LOG ? Its not created by default.

thanks,
Girish

 

[Marco Kalter]

Which PL/SQL Developer version are you using?