Re: Info about statpack analysis

From: evvivaiciccioni <cicico_at_cicciobello.it>
Date: Tue, 25 Oct 2005 20:58:23 +0200
Message-ID: <435e7fdd$0$8499$5fc30a8@news.tiscali.it>

it looks like this (i took it from the statpack report):

DELETE FROM D WHERE D.rowid=:"SYS_B_0"

the :"SYS_B_0" is due to the "cursor_sharing = force" in the init file.

"Michel Cadot" <micadot{at}altern{dot}org> ha scritto nel messaggio news:435e7f18$0$32759$626a14ce_at_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:58:23 CDT