Re: Shared Cursor

 (txu_at_softart.com) writes:

> Is there a shared cursor in Oracle? And what is that?

   Yes Oracle provides Shared SQL. What this means in a nutshell is that if two or more users are running the same SQL statements (for example the same customer order entry form) then Oracle keeps all of the information (parse tree, optimization plan, etc) for those statements in one area shared by all of the users. This can dramatically reduce memory requirements and alows many more concurrent users than if every user needed their own private copy of this information.

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##