Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    17

    Unanswered: Trying to undstand Statistics of SQL

    Dear All,

    I am trying to undestand the statistic of SQL.
    Can you please send me any link or file which describes the following
    parameters briefly?

    1 recursive calls -??
    0 db block gets -??
    6838 consistent gets - ??
    1103 physical reads -??
    0 redo size -??
    152390 bytes sent via SQL*Net to client -?
    5517 bytes received via SQL*Net from client -?
    457 SQL*Net roundtrips to/from client -?
    1 sorts (memory) -?
    0 sorts (disk) -?
    6840 rows processed -?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    For an overview read the SQL*Plus manual:
    http://download.oracle.com/docs/cd/B28359_01/server.111/b31189/ch8.htm#i1037226

    The most interesting number is "consistent gets". Here is a nice article from Tom Kyte:
    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:880343948514

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •