In running our Gather Schema for ALL schemas some interesting results popped up, one of which was the error message of “ORA-00900: invalid SQL statement” for a few objects. Researching what the items were by just running a select on the tables (OVCX_FINP_HLD_INVALIDS_0_0 and OVCX_FINP_HLD_PROFILES_0_0) I found that the items in question were actually tables in our system which were columns of HTML code which made up webpages when put together!!
Research on My Oracle Support finds this article "OVC Diagnostic Readme and Available Parameters" [ID 252733.1] which explains that these tables are artifacts of an older version of the Oracle Diagnostics, deprecated in lieu of the current Oracle Diagnostics bundle, and the tables were generated from the ovc.zip file which is still provided by Oracle via MOS Notes 297613.1 and 398834.1. While we only have a few of these objects in our system, reclaiming the space by dropping the tables won't be a whole lot for us by percentage, every byte is crucial and multiplied by every environment adds up to what your total storage budget is. Maybe you don't have any of these objects in your system laying around, but are you sure of it? Might be worth your time to go looking, don't you think?
No comments:
Post a Comment