Re: SQL Trace Qs

From: Tim Gorman <tim_at_sagelogix.com>
Date: Wed, 21 Apr 2004 07:42:52 -0600
Message-ID: <BCABD67C.138F2%tim@sagelogix.com>

Any chance you can post the lines from the "raw" trace file surrounding that EXEC line? You'd want to post any lines after the PARSE and prior to the first FETCH line as well. I'm guessing that there are some WAIT lines, assuming that you've traced at level 8 or above...

My suspicion is that it has something to do with the binding of the values for the bind variables, which depending on the API in use might show some "SQL*Net message from client" waits?

What API is in use here? JDBC? ODBC? Oracle Forms or Oracle Reports (a.k.a. OCI)?

on 4/21/04 5:13 AM, VIVEK_SHARMA at VIVEK_SHARMA_at_infosys.com wrote:

> Folks
>
> What could be the Cause for HIGH Value of elapsed time=3D3.27 in the
> following SELECT Queries?
>
> NOTE - It is doing a UNIQUE Index Scan=20
>
> Will provide any info required
>
> Thanks
>
>
> ************************************************************************
> ****
> SELECT COUNT(*)
> FROM
> TSD WHERE SCHM_CODE =3D :1 AND FLOW_CODE =3D :2
>
>
> call count cpu elapsed disk query current
> rows
> ------- ------ -------- ---------- ---------- ---------- ----------
> ------
> Parse 1 0.00 0.01 0 0 0 0
> Execute 268 0.08 3.27 0 0 0 0
> Fetch 268 0.04 0.11 0 536 0
> 268
> ------- ------ -------- ---------- ---------- ---------- ----------
> ------
> total 537 0.12 3.40 0 536 0
> 268
>
> Misses in library cache during parse: 1
> Optimizer goal: CHOOSE
> Parsing user id: 12 (TBAGEN)
>
> Rows Execution Plan
> ------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: CHOOSE
> 0 SORT (AGGREGATE)
> 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF
> 'TD_SCHM_DEFN_TABLE'
> 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF
> 'IDX_TD_SCHM_DEFN_TABLE' (UNIQUE)

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Apr 21 2004 - 08:39:52 CDT