Re: performance problem : tkprof show many fetches with high elapsed time

From: <mccmx_at_hotmail.com>
Date: 4 Jan 2007 01:56:07 -0800
Message-ID: <1167904567.327580.256550@51g2000cwl.googlegroups.com>

> So you too think that the update statements has updated more than 6000
> records ?
>
> Benny.
>

Yes. I do.

See below:

UPDATE PROFILESTOREDATA SET DATA=:1
WHERE ID=:2 call count cpu elapsed disk query current rows ------- ----- ----- ------- ------ ------- -------- ------

Parse      12   0.00    0.00      0       0        0       0
Execute    12  59.22  868.48  65205  211734   176298   72221
Fetch       0   0.00    0.00      0       0        0       0
------- -----  ----- ------- ------ ------- --------  ------
total      24  59.22  868.48  65205  211734   176298   72221

The rows column shows 72,221. If you divide that by 12 executions you get over 6,000.

Also the following section also confirms that you are updating 6395 rows.

Rows Row Source Operation

-------  ---------------------------------------------------

6395 UPDATE
6395 PARTITION RANGE SINGLE PARTITION: KEY KEY 6395 INDEX UNIQUE SCAN IDX_PROFILESTOREDATA PARTITION: KEY KEY (object id 18090)

I don't believe that the ID column is unique in that table...

Matt Received on Thu Jan 04 2007 - 03:56:07 CST