sqlplus connection slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sqlplus connection slow

  1. #1
    Join Date
    Apr 2001
    Posts
    69
    Hi,

    we have recently insalled oracle817 on vms. when we connect to sqlplus it takes long time to establish the connection only to this server. connection to other servers are OK. I tried tnsping on 3 servers.

    1. on UNIX.

    tnsping server1 50 --- very fast.. immediate.

    2. on VMS

    tnsping server2 50 - Not as fast as in the first case..2-4 secs....But it's OK.

    3. on VMS (newly installed oracle817)

    tnsping server3 50 ---- very slow..it takes longt time (4-8 secs).

    I have create prespawned procesess also. But still no appreciable improvement. listener.ora entries are ok. any solutions?

    Thanks,

    SPN

  2. #2
    Join Date
    Apr 2001
    Posts
    69
    Any tips?

    Thanks,

    SPN

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Did you check the network?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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