Re: Cursor Mismatch (V$SQL_SHARED_CURSORS.DESCRIBE_MISMATCH)

Any luck ???




________________________________
From: Asif Momen <asif_oracle_at_yahoo.com>
To: freelist freelist <oracle-l_at_freelists.org>
Sent: Sat, February 19, 2011 5:41:43 PM
Subject: Cursor Mismatch (V$SQL_SHARED_CURSORS.DESCRIBE_MISMATCH)


Hi,

I have an INSERT statement which shows up in V$SQL_SHARED_CURSOR view with a 
DESCRIBE_MISMATCH. It has more than 1200 records listed in V$SQL_SHARED_CURSOR  
view (all "Y" for DESCRIBE_MISMATCH) and is also consuming a lot of 
V$SQL.SHARED_MEM. 


Not much help is provided on Oracle Support/Google regarding DESCRIBE_MISMATCH. 
Could you please shed some light on this?

Here are the other details:

OS:  RHEL 5.5 (64-bit)
DB:  Oracle 11g R2 Patch 1 (11.2.0.2)
RAC:  Two node RAC
More Info:   The table contains BLOB columns


SELECT substr(sql_text,1,40) "Stmt", count(*),
                sum(sharable_mem)    "Mem",
                sum(users_opening)   "Open",
                sum(executions)      "Exec"
          FROM v$sql
         GROUP BY substr(sql_text,1,40)
        HAVING sum(sharable_mem) > 10*1024*1024;
Stmt                                       COUNT(*)        Mem       Open       
Exec
---------------------------------------- ---------- ---------- ---------- 
----------
INSERT INTO MY_TABLE ( REFEREN        294 2.7599E+10         10      11225


Thanks

Regards:  
Asif Momen



      

--
http://www.freelists.org/webpage/oracle-l