RE: PeopleSoft DBA Forum CURSOR_SHARING PARAMETER IN ORACLE
- 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.
From: R P [mailto:pjksel@...]
Sent: Wednesday, December 29, 2004 11:35 AM
Subject: PeopleSoft DBA Forum CURSOR_SHARING PARAMETER IN ORACLE
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.
PeopleSoft for the Oracle DBA is published by Apress - see
The PeopleSoft DBA Forum is managed by http://www.go-faster.co.uk
Yahoo! Groups Sponsor
Yahoo! Groups Links
* To visit your group on the web, go to:
* To unsubscribe from this group, send an email to:
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .