Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: What do you make of this?

RE: What do you make of this?

From: <Ravi_Kulkarni_at_Dell.com>
Date: Fri, 9 Sep 2005 14:38:07 -0500
Message-ID: <DB108C8A1E08EC448BB22A51DC9FAB627503BD@ausx3mpc111.aus.amer.dell.com>


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 ?         

> 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
Received on Fri Sep 09 2005 - 14:40:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US