Statistics

From: <sweidanz_at_yahoo.com>
Date: Mon, 8 Oct 2001 15:30:36 +1000
Message-ID: <FSaw7.441$m8.2682@nsw.nnrp.telstra.net>

Folks,
can anyone explain to me some of the statistics that we get when we run SET AUTOTRACE ON: Statistics

---

recursive calls
redo size
sorts (memory) and why sometimes its changed for the same query? db block gets
consistent gets (i know that one number of reads from buffer cache but whats the difference between this and db block gets?) and is that number of "blocks" read or soemthing else?

thanks,
ZS Received on Mon Oct 08 2001 - 00:30:36 CDT