Re: a performance question

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<b5fiq1$3ii$1$830fa17d_at_news.demon.co.uk>...
> It looks like one of the records was locked by another session.
>

What made you come to that Conclusion ???? Aggreed that this may be one of the reasons ... But stilll ....

Regards,
Ganesh R  

>
> --
> 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 Sat Mar 22 2003 - 11:12:19 CST