long time to execute Sql Query (initializing)

[Fabio Pinheiro]

Hi,
When I try execute a Sql Query, the time of response is very long!
In the status bar show me the follow message:
Initializing...

I try change the (%orahome%\Network\ADMIN\sqlnet.ora), but it continues slow..

What can I do to solve this?

thanks,

 

[BWendling]

Same here,

it seems to be correlated with database load,

What does PLSD do while "Initializing..."?

 

[Marco Kalter]

During "Initializing..." the SQL Window makes a secondary connection to the database. If this is slow, it may indicate an Oracle Net configuration issue. To verify this, go to Help > About, press the "Info" button, press the "Copy all pages" button on this info screen, and paste this text into an e-mail reply.

Note that this can generally be "fixed" by using "Dual Session" mode. Go to Tools > Preferences > Oracle/Connection page, and set the "Session Mode" to "Dual Session".

Fixing an Oracle Net configuration is recommended of course.

 

[Fabio Pinheiro]

Hi Marco Kalter,
thanks for the help!

Can you explain as can I correct the "Oracle Net configuration issue".

See the requested information bellow.

thanks,

--- Info ---

PL/SQL Developer
Version 6.0.5.931 (MBCS)
156.23641 - 5 user license
Windows XP version 6,0 (build 2600) Service Pack 1

Physical memory : 523.496 kB (262.976 available)
Paging file : 1.279.092 kB (1.049.888 available)
Virtual memory : 2.097.024 kB (2.011.584 available)

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

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

Plug-Ins

Aliases
SPO01P
SPO14P
tcs
tcs_prod
WEBDEV

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle8i Enterprise Edition Release 8.1.7.4.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora92
ORACLE_HOME_NAME = OraHome92
API = C:\oracle\ora92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = C:\oracle\ora92
NLS_LANG = NA

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = C:\oracle\ora92
NLS_LANG = BRAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
SQLPATH = C:\oracle\ora92\dbs
ORACLE_HOME_KEY = Software\ORACLE\HOME0

--- Path ---

C:\oracle\ora92\bin
C:\Program Files\Oracle\jre\1.3.1\bin
C:\Program Files\Oracle\jre\1.1.8\bin
C:\Program Files\Windows Resource Kits\Tools\
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Documents and Settings\agdias\.vmwebclient\Java\bin

--- TNS names ---

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SPO01P.LA.CORP.CARGILL.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.241.21)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SPO01P)
)
)

WEBDEV.LA.CORP.CARGILL.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.117.3.31)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SPO79D)
)
)

SPO14P.LA.CORP.CARGILL.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brspoa3h)(PORT = 1521))
)
(CONNECT_DATA =
(SID = SPO14P)
)
)

tcs.LA.CORP.CARGILL.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brspoa9h)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = spo20d)
)
)

tcs_prod.LA.CORP.CARGILL.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brspoa3h)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = spo45p)
)
)

 

[Marco Kalter]

Can you send me C:\oracle\ora92\network\admin\sqlnet.ora?

 

[Fabio Pinheiro]

Hi Marco Kalter,

---------------------------------------------

# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = la.Corp.Cargill.com

# SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
---------------------------------------------

thanks,

 

[Fabio Pinheiro]

Hi,
I found the solution for this problem.

There's a conflict with PlSql Developer and the firewall software Zone Alarm version 3.0.

I've uninstalled this version and installed the Zone Alarm 3.7 Integrit and the problem was resolved.

thanks,

 

[guy_bournival]

Hi,

I have the same problem. (When I try execute a Sql Query, the time of response is very long!In the status bar show me the follow message:Initializing...)

I tried the latest trial version and the problem have gone away for. My version is 6.0.0.840. I have also 5.1.4.728 on a computer and it running perfectly...

Could you help me to fix my version (6.0.0.840)?

Thanks,

 

[Marco Kalter]

Can you check if this line:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

is present in the sqlnet.ora file in the network\admin subdirectory in your oracle home directory? Nine out of ten times this is the culprit.

 

[Makker]

I've encountered that using Oracle 10g under Windows setting up the connection takes quite a long time. This counts for logging in but also for setting up a connection when a new window is opened.
Using Oracle 10g under Linux is significant faster. I use both databases/OS's in an VMWare session, while using PSD in the host OS (Windows XP).
The "Linux"-Database is surprisingly fast, while the "Windows"-database is slow in setting up connections.
I've no idea what causes this problem yet, but maybe it gives you a clou? (you didn't mention what OS is running your database).

Using the 10g client also might help (a little). Mark that Oracle has an instantclient for 10g, which is a leight-weight 10g-client. This is a relatively small zip file that can be extracted to a directory and contains only the OCI.dll and necessary resource files. Simply extract, set your TNS_ADMIN, Path and NLS_LANG environment-variables and run Pl/Sql Developer against it. So there's no need for a large Client-Oracle Home installation when only using Pl/Sql Developer and/or sqlplus. For (character-based) sqlplus there is another zip-file that can be extracted in the same directory.

Regards,
Martien

 

[Dan reidy]

I now have an "Initilizing..." problem with v7.0.
I'll execute something, it says "Initializing...", and rever responds. It is periodic, and did not exist in v6. 90%+ of the time my queries run fine, but several times a day I am forced to kill the app, and restart it, then the same query run fine.

I have "Session Mode = Milti session" (always have). Since it usually runs fine, I'm inclined to think it is not an sqlnet.ora issue or a firewall issue.

I'm pretty frustrated. I really like the new v7 features, but I cant keep using it like this.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[William Robertson]

Interesting - I noticed that a colleague used to wait a while each time for "Initializing...", and then later I found out that he used multi-session and I was using dual session (always have, assumed everyone did). The issue that brought it to our attention was that he couldn't query his temp tables after a batch job and I could (since my SQL window was in the same session as the test window). I never thought about the "Initializing" step being part of session creation. Thanks!

 

[Eggie]

Is there also a new new session being created when I open the Large Data Editor? I don't have any problems with the normal SQL Windows but as soon as I open the LDE then it may take up to 45 secs before the CLOB's data pops up. I noticed the same behaviour as Makker did. It's lightning fast under Linux (Client Server) but whilst running a database on Windows XP it's a nightmare. Tried various Net10 setups

 

[Marco Kalter]

No, the Large Data Editor does not use a secondary session. What is the size of this CLOB? Is it an XML text?

 

[Eggie]

Yes, it's a XML text.
I did some additional testing. Logged in from another client to the XP Oracle database and got about the same performance as under Linux, fast, so it must be something local. Switched off all firewall and anti virus software but still slow performance when on the local machine, weird. Onky the Large Editor has this behaviour. All other windows work as expected.

 

[Marco Kalter]

It's probably an MSXML issue on this particular PC. Assuming that this only occurs for XML content.

 

[Eggie]

No, this is not XML related. If I do: New test window, create a temporary Clob variable and click on [...] to edit it's content then it will take same amount of time. So this is an empty Clob.