Soliciting feedback regarding pscbo_stats
As many of you know, pscbo_stats is a tool that provides an alternative way of managing statistics for PeopleSoft applications running on Oracle. This tool leverages dynamic sampling and a consistent methodology for gathering statistics at both the table and schema level. See this KM Doc for details:
pscbo_stats - Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise (Doc ID 1322888.1)I'm soliciting feedback from users that have worked with it. Regardless if you saw improvements or not, I'm interested in your experience.
- What was your experience using pscbo_stats? Did you notice any performance or stability changes? If so, describe.