Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> anyone using shared_cursors=FORCE under 8.1.6?

anyone using shared_cursors=FORCE under 8.1.6?

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Mon, 9 Oct 2000 18:05:21 -0500
Message-ID: <su4jigo8rdqocb@corp.supernews.com> 






We have an application that is very high transaction which uses no bind
variables.  The sqlarea portion of the library cache had a hit ratio around
45%.  We set shared_cursors=FORCE in our init.ora and after a week of being
up the ratio is now 97.8%



Wondering if anyone else is using this parameter and if so, have there been
any problems that you have noticed other than some statements may choose an
undesireable execution plan (which we have not noticed)


--
Dave A


Received on Mon Oct 09 2000 - 18:05:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US