v$session_wait
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: v$session_wait

  1. #1
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    Our application/database is running very slow, nothing seems to be wrong with the instance everything seems fine except for slog redo log writes. I see a lot of the following waits in
    v$session_wait.
    Event Wait_time State
    pmon timer 0 waiting
    rdbms ipc message 0 waiting
    rdbms ipc message 0 waiting
    SQL*Net message from client 0 waiting
    SQL*Net message from client 0 waiting
    SQL*Net message from client 0 waiting
    SQL*Net message from client 0 waiting
    pipe get 0 waiting
    pipe get 0 waiting


    What do these indicate? I read somewhere that the wait_time 0 indicate there is problem in the network? How do I find out and tune this?

    Thanks in advance.


    KN

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    You generally do not need to worry about SQL Net messages if you are sure that your network is fine because what they mean is the server is waiting for the client to respond to something or pass on some input.

    The problem lies elsewhere.

    Nizar

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Nabaig is right.

    Have you tried any performance tuning scripts ?
    buffer hit ratios
    I/O stats
    rollstat
    sort stats
    etc

    have you tried tracing slow session and analyzing sql ?
    this can result in major gains !

    have you tried querying v$waitstat, v$sysstat etc ?

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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