Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sorting In memory

Sorting In memory

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Mon, 4 Dec 2000 15:24:05 +0900
Message-Id: <10699.123505@fatcity.com>


Hello,

IN the v$sysstat table exactly waht is the meaning of the fields class and value.

For example For OLTP systems 95% of sorts should be in memory.if i am incorrect please tel me.

I got the values like this.

Name							CLass   Value
       sorts (memory)
64      14192
        sorts (disk)
64         87
        sorts (rows)
64     721124


Please explain me about the above query. Received on Mon Dec 04 2000 - 00:24:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US