SQL NET Tuning- Wait time very large
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL NET Tuning- Wait time very large

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Sqlnet message to client wait time is very high.
    How can I tune it ?
    Does any body has used SDU,TDU, array_size parameters.
    Will you please give me the realtime example of sizing this parameters. My block size is 8192k , oracle 8.1.6, linux
    Database is connected via apache application server.

    Your help is appreciated..

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    you dont tune that
    itīs not really waits, itīs just that the server has nothing to send to the client

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    No Pando, it is a wait time is increasing database is 24/7.
    Due to that some time application server dying.
    I can see acvtivities through OEM and spotlight

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    As pando allready said, this "SQL*Net mesage to client" wait event is not causing you any problems. This is one of those idle wait events in a database that allways grow (and actually consume the most wait time in wait event statistics) but are actually inevitable but have no influence on the performance. You should simply ignore them. Some other idle wait events are:
    - pmon timer
    - smon timer
    - SQL*Net message from client
    - SQL*Net more data from client
    - rdbms ipc message
    - null event
    - .....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Aug 2000
    Location
    Brazil
    Posts
    1

    Post

    well, first, you need verify your indexes and tables, maybe your objects was be fragmented.

    Maybe the space reserved for transactions is very small, you need defined with pct inrease and free list paramters...

    Try it

    []'s



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