Skip to Content
author's profile photo
Former Member

What do numbers mean in Stmt of BUFFER TRACE?

Hello,

if I switch on a buffer trace, I get a list with a column named 'statement'.

This column shows the parameters of the query.

Each stmt contains first the Buffering type (P-single table records buffered, R-complete table

buffered, G-key value areas in table buffered).

Next, a number follows. For example a 0, or a 67 or 30 etc.

What do these numbers mean???

I can't find information anywhere like so often...

Does naybody know sth.?

thanks in adv.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 01, 2005 at 09:09 AM

    Hi Holger,

    The number that follows in the column "statement" is the length of "KEY" of that table . Just double click on this column on any of rows and you will see the details.

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 30, 2005 at 01:44 PM

    Looks different in our system

    Duration

    Objectname

    Oper

    Rec

    RC

    Statement

    The statement summary looks that way

    Executions

    Identical

    Duration

    Records

    Time/exec

    Rec/exec

    Avg.time/r

    Min.time/r

    Length

    Btype

    Tabtype

    Objectname

    SQL-Statement

    Which one do you mean?

    Christian

    I can see it now - you mean the Statement itself -

    F1 on the field statement reveals the mystery:

    It is the length of the key.

    Christian

    Message was edited by: Christian Finkbeiner

    Message was edited by: Christian Finkbeiner

    Add comment
    10|10000 characters needed characters exceeded