Loading ...
Sorry, an error occurred while loading the content.

RE: PeopleSoft DBA Forum CURSOR_SHARING PARAMETER IN ORACLE

Expand Messages
  • Zeng, Lei
    We are on Oracle 9204 and PeopleTool 844. When using cursor_sharing =SIMILAR. we hit Oracle Bug: 2843601. This bug is supposed to be fixed on Oracle 9205 but
    Message 1 of 1 , Dec 30, 2004
    • 0 Attachment
      We are on Oracle 9204 and PeopleTool 844. When using cursor_sharing
      =SIMILAR. we hit Oracle Bug: 2843601. This bug is supposed to be fixed
      on Oracle 9205 but we haven't got chance to test it yet. There may be
      other bugs and please search Metalink.

      Lei
      Database Administrator
      Vicor Corp.

      ________________________________

      From: R P [mailto:pjksel@...]
      Sent: Wednesday, December 29, 2004 11:35 AM
      To: psftdba@yahoogroups.com
      Subject: PeopleSoft DBA Forum CURSOR_SHARING PARAMETER IN ORACLE


      Hi,
      We are running Financials 8.4 tools 844.14 and
      recently upgraded from Oracle 8i to 9i (9205) and had been using the
      cursor_sharing parameter. We had been setting it to EXACT, as it was
      recommended that we do that by some load testing experts. However, it
      seems like to me that Peoplesoft uses bind variables in most or all of
      their programs, and setting this parameter to EXACT will not provide any
      benefit and can actually cause the optimizer to choose bad plans on
      certain queries. Also, setting this parameter causes histograms to be
      ignored as Oracle is replacing literals with bind variables. In Oracle
      9i there is a new value for which cursor sharing parameter can be set.
      It is similar.

      Has anyone ever experimented with using the cursor_sharing parameter, or
      can anyone provide more information about this.
      Thanks a bunch,

      ________________________________

      Do you Yahoo!?
      Yahoo! Mail - 250MB free storage. Do more. Manage less.
      <http://us.rd.yahoo.com/evt=29915/*http://info.mail.yahoo.com/mail_250>


      PeopleSoft for the Oracle DBA is published by Apress - see
      http://www.psftdba.com
      The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk




      Yahoo! Groups Sponsor
      ADVERTISEMENT
      click here
      <http://us.ard.yahoo.com/SIG=129mjcjsj/M=295196.4901138.6071305.3001176/
      D=groups/S=1707698825:HM/EXP=1104509791/A=2128215/R=0/SIG=10se96mf6/*htt
      p://companion.yahoo.com>

      <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
      s/S=:HM/A=2128215/rand=418066027>

      ________________________________

      Yahoo! Groups Links


      * To visit your group on the web, go to:
      http://groups.yahoo.com/group/psftdba/

      * To unsubscribe from this group, send an email to:
      psftdba-unsubscribe@yahoogroups.com
      <mailto:psftdba-unsubscribe@yahoogroups.com?subject=Unsubscribe>

      * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
      Service <http://docs.yahoo.com/info/terms/> .
    Your message has been successfully submitted and would be delivered to recipients shortly.