RE: What do you make of this?

Is it No to Index or is it a No to Trigger ..

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Baumgartel Sent: Friday, September 09, 2005 11:52 AM To: Deepak Sharma
Cc: Kulkarni, Ravi; oracle-l_at_freelists.org Subject: Re: What do you make of this?

No, but I wouldn't think that would affect parse elapsed time.

On 9/9/05, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com > wrote:

        Any index on lastaccess ?         

• Ravi_Kulkarni_at_Dell.com wrote:

> Paul,
>
> Can you confirm any (before-update) triggers on
> VALIDKEYS ?
> What are the cursors that the raw trace file show
> (with dep > 0) ?
>
> Thanks,
> Ravi.
>
> ________________________________
>
> From: oracle-l-bounce_at_freelists.org
> [mailto: oracle-l-bounce_at_freelists.org
<mailto:oracle-l-bounce_at_freelists.org> ] On Behalf Of

> Paul Baumgartel
> Sent: Friday, September 09, 2005 11:18 AM
> To: oracle-l_at_freelists.org
> Subject: What do you make of this?
>
>
> Hi, all. Oracle10g (10.1.0.4.0) on Windows 2000.
>
> I have a set of traces that are puzzling. I had the
> traces done in
> controlled conditions, with a single user on the
> database; CPU usage on
> the DB server was less than 25%. This statement is
> a good example of
> what I'm trying to figure out. There's a high ratio
> of elapsed to CPU
> on the parse, but not much in the way of wait
> information--except the
> SQL*Net message from client. The client is a COM+
> application server.
> No recent changes that I know of on that machine,
> nor on the DB server
> itself. I have inspected the raw trace file as well
> and don't see
> anything to suggest that the tkprof timing summaries
> are incorrect.
>
> II'm looking for ideas on how to go about diagnosing
> the SQL*Net waits
> (assuming they're accounting for the different
> between CPU and elapsed)
> or finding where the rest of the elapsed time comes
> from. Thanks in
> advance for any suggestions!
>
> UPDATE VALIDKEYS SET LASTACCESS = :V00001
> WHERE
> VALIDKEYS_PK = :V00002
>
>
> call count cpu elapsed disk
> query current
> rows
> ------- ------ -------- ---------- ----------
> ---------- ----------
> ----------
> Parse 198 0.46 2.72 0
> 0 0
> 0
> Execute 99 0.12 0.49 0
> 297 396
> 99
> Fetch 0 0.00 0.00 0
> 0 0
> 0
> ------- ------ -------- ---------- ----------
> ---------- ----------
> ----------
> total 297 0.59 3.22 0
> 297 396
> 99
>
> Misses in library cache during parse: 0
> Optimizer mode: ALL_ROWS
> Parsing user id: 12492
>
> Elapsed times include waiting on following events:
> Event waited on Times
> Max. Wait Total
> Waited
> ---------------------------------------- Waited
> ----------
> ------------
> SQL*Net message to client 381
> 0.00
> 0.00
> SQL*Net message from client 381
> 0.01
> 0.51
> log file sync 1
> 0.00
> 0.00
>
        

> ********
>
> --
> Paul Baumgartel
> paul.baumgartel_at_aya.yale.edu
>
>
>
                 

	Do You Yahoo!?
	Tired of spam?  Yahoo! Mail has the best spam protection around
	http://mail.yahoo.com
	

-- 
Paul Baumgartel
paul.baumgartel_at_aya.yale.edu



--
http://www.freelists.org/webpage/oracle-l