Freezes

[Kishu]

Everytime when i try to run screen freezes during for the first time and after that it takes lot of time for intialization,

FYI: I already switched off "Show Dictionary info in grid"

 

[Marco Kalter]

If it freezes when the message on the status line is "Initializing", then this may indicate that there is an Oracle connection delay.

This may be caused by an Oracle configuration issue. Can you start PL/SQL Developer, go to Help > Support Info and send me the text from the "Info" tab page?

 

[Kishu]

PL/SQL Developer
Version 12.0.4.1826 (64 bit)
01.115327 - 50 user license
Service Contract: 9/1/2018
Windows 10 Build 14393

Physical memory : 8,274,356 kB (3,491,296 available)
Paging file : 10,436,716 kB (2,334,888 available)
Virtual memory : 137,438,953,344 kB (137,404,712,264 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Users\username\AppData\Roaming\PLSQL Developer 12\Preferences\default\Default.ini
C:\Users\username\AppData\Roaming\PLSQL Developer 12\Preferences\username\default.ini

License File
C:\ProgramData\PLSQL Developer\aalf.dat

Debug file
C:\Users\username\AppData\Roaming\PLSQL Developer 12\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)

Aliases
12:17AM9/24/2007CHEVRONMIKE
CHEVRONMIKE
COMDATA
COOPERDD
ECRDP.ORADB.CHEVRONTEXACO.NET
...

Homes
OraClient12Home1 (C:\app\client\username\product\12.1.0\client_1)

DLLs
C:\app\client\username\product\12.1.0\client_1\bin\oci.dll

TNS File
C:\app\client\username\product\12.1.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient12Home1
DLL: C:\app\client\username\product\12.1.0\client_1\bin\oci.dll
OCI: version 12.1
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: AL32UTF8

Process
Working Set = 163,962,880
Memory = 110,760,584
GDI Objects = 1011
User Objects = 2258
Handles = 982

Monitor
PixelsPerInch = 96

Id = 0
Primary = True
Handle = 65537
Left = 0
Top = 0
Width = 1920
Height = 1080

MainFormOnTaskbar = False

 

[Kishu]

Can i get a reply for the above please???

 

[Marco Kalter]

Can you also send me the following file?

C:\app\client\username\product\12.1.0\client_1\Network\Admin\sqlnet.ora

 

[Kishu]

# sqlnet.ora Network Configuration File: C:\app\client\username\product\12.1.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 

[Kishu]

Why you people takes a day to reply?

 

[mike]

They are possibly almost on the other side of the world from you. They are for me anyway. One day isn't bad service.

 

[Marco Kalter]

Can you change this line:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

To this:

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

This change can dramatically reduce connection times.

Note that for faster support turn-around times you can send a mail to support@allroundautomations.com.

 

[Kishu]

No Performance changes