slow oracle connections
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: slow oracle connections

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    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 .

  2. #2
    Join Date
    Feb 2004
    Posts
    35
    use explain_plan and tkprof to see where the delay is.

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    can we trace odbc connection timings by setting any variable in sqlnet.ora ... ??

  4. #4
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    if it is the problem in getting connection,
    then you can think of enabling connection pooling.

  5. #5
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    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

  6. #6
    Join Date
    Feb 2004
    Posts
    50
    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?

  7. #7
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    tracing if switched off ...

    are there any tools where we can test oracle connectivty time through odbc

  8. #8
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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

  9. #9
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    it is dedicated server and 100 connections are present at any point of time .

  10. #10
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    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
  •  



Click Here to Expand Forum to Full Width