Hi
Is there any tool to find out Oracle connections to application (via ODBC, etc) seem to be a lot slower recently.
Do you have any metrics you can give me on this?
hi is there any way we can find this connectivuty time .
appreciate your feedback .
Printable View
Hi
Is there any tool to find out Oracle connections to application (via ODBC, etc) seem to be a lot slower recently.
Do you have any metrics you can give me on this?
hi is there any way we can find this connectivuty time .
appreciate your feedback .
use explain_plan and tkprof to see where the delay is.
can we trace odbc connection timings by setting any variable in sqlnet.ora ... ??
if it is the problem in getting connection,
then you can think of enabling connection pooling.
We are using connection pooling ...
TNS CONNECTIONS IS TAKING LOT OF TIME HOW CAN I FIX THIS PROBLEM .
is there anything that , we can tune at oracle database ?
C:\>tnsping 64.37.242.101 8
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 01-MAR-2004 17:12:53
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=64.37.242.101)(PORT=1521))
OK (70 msec)
OK (60 msec)
OK (3020 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
OK (20 msec)
C:\>ping 64.37.242.101
Pinging 64.37.242.133 with 32 bytes of data:
Reply from 64.37.242.101: bytes=32 time=10ms TTL=253
Reply from 64.37.242.101: bytes=32 time=30ms TTL=253
Reply from 64.37.242.101: bytes=32 time=10ms TTL=253
Reply from 64.37.242.101: bytes=32 time<10ms TTL=253
I've seen problems with slow connections if Oracle Trace is enabled.
Are there any large files under: $ORACLE_HOME/otrace/admin
e.g. process.dat, collect.dat and regid.dat
If so, then you can switch off tracing in the listener.ora by setting EPC_DISABLED
If not, do you have Oracle Net tracing switched on?
tracing if switched off ...
are there any tools where we can test oracle connectivty time through odbc
Dedicated or shared server connection? Pooling enabled?
it is dedicated server and 100 connections are present at any point of time .
I have a few suggestions:
1. Try changing the config to Shared Server
2. Run Statspack. Before running statspack set time_statistics to true.
Statspack report will help you tune the shared server.
