sqlplus login slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: sqlplus login slow

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question sqlplus login slow

    I have a database on windows 2003 x64bit that is slow at logon.
    This is true for sqlplus or any application at logon. Once logged in, it is very fast, no performance problems. This server has 32GIGS of RAM. The SGA is 10GIGS, 20GIGS free. Its very strange, because all other windows and solaris db servers do not have this logon problem. I also set client level tracing in sqlnet.ora, and there is no problem that I can see. When I do a tnsping, it is very fast, almost immediate. I also bypassed the listener(no alias) by logging in dbserver. Same login problem. So I assume its not a listener problem. I am running out of ideas.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    trace the connection - see where the time is being taken

  3. #3
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    Do you mean netstat ? I couldn't find anything significant after I set TRACE_LEVEL_CLIENT=16.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, trace the database connection - just like you would with any slow process

  5. #5
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    dave. Would you please tell how can we trace a connection process? Or you just meant through User Trace files in USER_DUMP_DEST?
    lucky

  6. #6
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Hi,

    Is there any logon trigger available? Check glogin.sql in server side.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

  7. #7
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    No logon triggers. Its very strange, it takes 8 seconds to logon to a windows 2003 x64 server (32GIG RAM) and 1 second on a windows 2003 32 bit (8 GIG RAM) server. Same database on different platforms. Maybe an OS config issue ? Why the difference ? Any recommendations.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes - trace the connection, see where the time is being taken

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