Re: SQL Trace Qs
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Apr 2004 07:42:52 -0600
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@xxxxxxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
