Re: Info about statpack analysis

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 25 Oct 2005 20:51:10 +0200
Message-ID: <435e7f18$0$32759$626a14ce@news.free.fr>

"evvivaiciccioni" <cicico_at_cicciobello.it> a écrit dans le message de news: 435e74e9$0$8481$5fc30a8_at_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.
|
|

DELETE FROM DDDDD WHERE DDDDDDD.rowid=:"SYS_B_0" is not a valid statement, are you sure you posted exactly what you have?

Regards
Michel Cadot Received on Tue Oct 25 2005 - 13:51:10 CDT