Trace: • Oracle Database - System Identifier (SID) • Oracle Database - skip_unusable_indexes parameter • Oracle Database - SORT_AREA_SIZE parameter • Oracle Database - SORT JOIN (or SORT MERGE JOIN) • Oracle Database - sorts (Disk) • Oracle Database - sorts (memory) statistics • Oracle Database - Space • Oracle Database - server parameter file (spfile) • Oracle Database - SQL Access Advisor (Summary Advisor) • SQL*Net roundtrips to from client
You are here: Home » Database management system (DBMS) » Oracle Database » SQL*Net roundtrips to from client

SQL*Net roundtrips to from client

About

SQL*Net roundtrips to from client is a statistics that you can see in the autotrace_statistics and means :

  • How much SQL*Net mesages are sent to and received from the client. This includes round-trips for fetches from a multiple-row result set.

How to minimize it ?

Oracle Database - Array size effect on the logical I/O and SQL*Net roundtrips

  • Bookmark "SQL*Net roundtrips to from client" at del.icio.us
  • Bookmark "SQL*Net roundtrips to from client" at Digg
  • Bookmark "SQL*Net roundtrips to from client" at Ask
  • Bookmark "SQL*Net roundtrips to from client" at Google
  • Bookmark "SQL*Net roundtrips to from client" at StumbleUpon
  • Bookmark "SQL*Net roundtrips to from client" at Technorati
  • Bookmark "SQL*Net roundtrips to from client" at Live Bookmarks
  • Bookmark "SQL*Net roundtrips to from client" at Yahoo! Myweb
  • Bookmark "SQL*Net roundtrips to from client" at Facebook
  • Bookmark "SQL*Net roundtrips to from client" at Yahoo! Bookmarks
  • Bookmark "SQL*Net roundtrips to from client" at Twitter
  • Bookmark "SQL*Net roundtrips to from client" at myAOL
 
database/oracle/sql_net_roundtrips_to_from_client.txt · Last modified: 2009/09/26 10:09 by gerardnico