Cursor Mismatch (V$SQL_SHARED_CURSORS.DESCRIBE_MISMATCH)
- From: Asif Momen <asif_oracle@xxxxxxxxx>
- To: freelist freelist <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 19 Feb 2011 06:41:43 -0800 (PST)
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
Other related posts:
