pscbo_stats v3 (11.4.6.2) posted to Note 1322888.1
An update to the pscbo_stats script has been posted to Note 1322888.1. Upgrade is simple rerunning the installation script, no other changes are necessary.
"v3" (11.4.6.2) focused on fixing minor bugs and enhancements. These include:
- Fixed identification of Oracle table name when queried by PeopleTools record name and a SQLTABLENAME existed for that record. (fixed)
- Base tables for PeopleTools temporary table records are added statistics control table during setup. (fixed)
- When histogram exception is processed, estimate_pct is now 100% (improved)
- Log when gather of stats is requested on unsupported tables, e.g. iot, recycle bin, dr%, external tables, etc. (improved)
- Setup_schema_stats() honors DEGREE table preference regardless of table size (improved)