October 25, 2011
The NYOUG tech journal the NYOUG March 2011 meeting is available at http://www.nyoug.org/info/tech_journal/2011/NYOUG_TechJournal_June2011.zip.
Many great papers! Mine starts at page 35. The revised copy of my presentation can be found at http://iiotzov.files.wordpress.com/2011/08/iotzov_oem_repository.pdf
August 26, 2011
Special thanks to Wayne Taylor for pointing out a mistake I made on page 6 in my presentation Unleash the Value of the Data in Your OEM Repository. A corrected and slightly extended version of the presentation can be found here.
The following clause “to_char(rollup_timestamp,’DAY’) not in (‘SATURDAY’,'SUNDAY’)” does not have the desired effect.
The correct clause would be “to_char(rollup_timestamp,’FMDAY’) not in (‘SATURDAY’,'SUNDAY’)”.
I actually use “to_char(rollup_timestamp,’D') not in (1,7)”, but decided to include something more user-friendly for the presentation without much testing…
On a separate note – the documentation for the OEM Repository table/view structures for OEM 11g are now available – http://download.oracle.com/docs/cd/E11857_01/em.111/e12135/toc.htm . It appears that all structures in OEM 10g are present in 11g as well. That means that we can move any custom views and packages built for OEM 10g without much effort.