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

From: yong huang <yong321_at_yahoo.com>
Date: Fri, 20 Oct 2000 12:36:58 -0700 (PDT)
Message-Id: <10655.119879@fatcity.com>

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. Received on Fri Oct 20 2000 - 14:36:58 CDT