RE: 10g slowdown

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Fri, 12 Dec 2008 14:02:34 -0600 (CST)
Message-ID: <5ac546419afae5dae3f814e8d953cc9f.squirrel@society.servebeer.com>


Beware that there is also what I believe to be a bug where all values for the columns in v$sql_shared_cursor are "N", despite multiple children. Oracle Support had no answer for me and I had no more time to spend on it. I first noticed it at my last job on 10.2 and now here on 10.1 -- two different companies, two completely different applications, one using binds on a 3-tier web app, the other a client-server model not using binds. The only thing in common is the DBA... :)

Rich

> Check out this article - it has some good information to help explain what
> you are seeing...
>
> www.oracle.com/technology/oramag/oracle/08-jan/o18asktom.html

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 12 2008 - 14:02:34 CST

Original text of this message