"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message
news:a8aed4.0303220912.7f05e993_at_posting.google.com...
> "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
> > >
Low CPU ;high execute elapsed. Not waiting for disk IO. Parse and Fetch
times are very low.
Jim
Received on Sat Mar 22 2003 - 11:48:46 CST
