We received notice of a patch to correct the bug I discussed with gathering stats on tables with virtual columns/function-based indexes in parallel in my previous post. The patch is number 10013177 and can be found at https://updates.oracle.com/download/10013177.html.
After applying the patch, all stats collections worked without error. Whew!
skip to main |
skip to sidebar
In Memory of Amy Morton Workman 1971-2014
Meanderings of one who is lucky enough to have her avocation be her vocation.
Pages
About Me
Disclaimer
All content and technical information contained on the site is the professional opinion of the author and is in no way connected to a current or any prior professional affiliations/employment.
Fight Carcinoid Cancer!
In Memory of Amy Morton Workman 1971-2014
Books
Enkitec Blogs & Links
Links & Blogs
Proud Member
1 comment:
Thanks for posting your findings Karen. We ran into a similar issue with our database on 11.2.0.2, table with function based indexes, stats jobs failed. I did find that we had a weird data issue, a varchar2(6), byte semantics field had a record with containing 44 bytes.
We had to delete that record, and rebuild all associated indexes to get dbms_stats to run.
Found that record by creating the offending table in another schema with no records, and then did an insert from the offending table and it error on with value to large for column.
Anyhow, thanks for posting!
Rob
Post a Comment