Re: long running select min(timestamp) query

From: <bobdurie_at_gmail.com>
Date: Wed, 30 Jan 2008 09:24:16 -0800 (PST)
Message-ID: <054191fc-31c0-43c9-8127-ce30b2d93889@v46g2000hsv.googlegroups.com>

I performed this test, heres what i got:

BEFORE:
NAME
VALUE

---

---

consistent gets
1656576
consistent

changes                                                       49
data blocks consistent reads - undo records
applied                      43
cleanouts and rollbacks - consistent read
gets                            0

AFTER:
NAME
VALUE

---

---

consistent gets
1775792
consistent

changes                                                       49
data blocks consistent reads - undo records
applied                      43
cleanouts and rollbacks - consistent read
gets                            0

DIFF:
NAME
VALUE

---

---

consistent gets
119216
consistent

changes                                                       0
data blocks consistent reads - undo records
applied                      0
cleanouts and rollbacks - consistent read
gets                            0

Looks like a lot of consistent gets... Received on Wed Jan 30 2008 - 11:24:16 CST