-
slow oracle connections
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.
-
do we need any tuning from database end to fix this
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?
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
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.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|