Info about statpack analysis

From: evvivaiciccioni <cicico_at_cicciobello.it>
Date: Tue, 25 Oct 2005 20:11:41 +0200
Message-ID: <435e74e9$0$8481$5fc30a8@news.tiscali.it>

Hi,
i'm using statpack in order to improve the performance of a Oracle 9.2.0.6 Server on HPUX, in the report, i found this:

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------

21,680,275 78 277,952.2 22.9 90.69 90.38 3666391050
Module: ? @SSSS (TNS V1-V3)
DELETE FROM DDDDD WHERE DDDDDDD.rowid=:"SYS_B_0"

I'm confused, infact as far i know, the rowid access should be the fastest method, it contains the physical address of the row (maybe some other consideration may apply in case of RAC, but it is not my case) but this query gets more than 21.000.000 buffers for 78 executions ....... i expect to see... about 78 buffers... (in case of chained row, it may be greather).

What's wrong ???????????

Thanks. Received on Tue Oct 25 2005 - 13:11:41 CDT