Re: Why do I have multiple copies of identical sql reported by v$sql?

That was not it. I then listed the address with the sql_text and executions.

All six statements have the same address. It turns out the middleware has 6 sessions inserting rows into the table. v$sql is reporting each session's numbers.

My sidekick and I recently returned from the Oracle Internals seminar and were both surprised when we discovered this. This are a lot more complicated then we've been lead to believe.
----- Original Message -----
From: yong huang <yong321_at_yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, October 20, 2000 3:40 PM
Subject: Re: Why do I have multiple copies of identical sql reported by v$sql?

> Hi, Tom,
>
> You're only looking at the first 80 characters of the SQL statement. Try
> looking at SQL_TEXT in v$sql_text (or v$sql_text_with_newlines), but remember
> to concatinate the strings order by PIECE.
>
> Yong Huang
> yong321_at_yahoo.com
>
> you wrote:
>
> This is a single instance database, 8.0.5.0, parallelism degree 4 (used =
> only for recovery, all objects are degree 1).
>
> There are 6 identical cursors, each with different execution counts =
> reported by v$sql.
>
> sql> select sql_text text, decode(command_type,2,'INSERT'), executions
> from v$sql
> where command_type =3D 2
> order by executions desc;
>
> TEXT =
> DECODE EXECUTIONS
> -------------------------------------------------------------------------=
> ------- ------ ----------
> INSERT INTO VAL_ERR ( IP_ADDRESS,SITE_CODE,ATTEMPT_DT,PAGE,SESSION_ID ) =
> VALUES INSERT 543572
> ( :b1,:b2,SYSDATE,:b3,:b4 )
> [snipped]
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: yong huang
> INET: yong321_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 20 2000 - 16:26:41 CDT