It looks like one of the records was locked by another session.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
For one-day tutorials:
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______April 8th
____UK_______April 22nd
____Denmark May 21-23rd
____USA_(FL)_May 2nd
Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____UK_(Manchester)_May
____Estonia___June (provisional)
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
"Jay" <jwu_at_nctr.fda.gov> wrote in message
news:R1Hea.62$N5.5044_at_mencken.net.nih.gov...
> I do have the trace and tkprof as below. Can any expert provide
insight?
> Thanks.
>
> TKPROF: Release 9.2.0.1.0 - Production on Thu Mar 20 11:44:59 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Trace file: ./prod_s001_925908.trc
> Sort options: default
>
>
**********************************************************************
******
> ****
> count = number of times OCI procedure was executed
> cpu = cpu time in seconds executing
> elapsed = elapsed time in seconds executing
> disk = number of physical reads of buffers from disk
> query = number of buffers gotten for consistent read
> current = number of buffers gotten in current mode (usually for
update)
> rows = number of rows processed by the fetch or execute call
>
**********************************************************************
******
> ****
>
> UPDATE request
> SET print_flag = 'Y'
> WHERE lib_proc_nbr > 125636 AND lib_proc_nbr < 125737
>
> call count cpu elapsed disk query current rows
> ------- ------ ----- ---------- ------ ---------- ---------- ------
> Parse 0 0.00 0.00 0 0 0 0
> Execute 1 0.01 920.27 0 6 99 96
> Fetch 0 0.00 0.00 0 0 0 0
> ------- ------ ----- ---------- ------ ---------- ---------- ------
> total 1 0.01 920.27 0 6 99 96
>
> Misses in library cache during parse: 0
> Misses in library cache during execute: 1
> Optimizer goal: CHOOSE
> Parsing user id: 492 (****)
>
> Rows Execution Plan
> ------- ---------------------------------------------------
> 0 UPDATE STATEMENT GOAL: CHOOSE
> 0 UPDATE OF 'REQUEST'
> 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'RDDEQUEST_LIBPROCNBR'
> (UNIQUE)
>
>
>
>
>
**********************************************************************
****
>
> OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
>
> call count cpu elapsed disk query current
rows
> ------- ------ ----- ---------- ------- ---------- ---------- ----
--
> Parse 0 0.00 0.00 0 0 0
0
> Execute 1 0.01 920.27 0 6 99
96
> Fetch 0 0.00 0.00 0 0 0
0
> ------- ------ ----- ---------- ------- ---------- ---------- ----
-
> total 1 0.01 920.27 0 6 99
96
>
> Misses in library cache during parse: 0
> Misses in library cache during execute: 1
>
Received on Fri Mar 21 2003 - 11:32:52 CST
