APEX and OEM data…a match made in heaven!

I’ve always been a BIG fan of Oracle Enterprise Manager, especially the information that can be extracted from the repository. Since version 11, the information has been used to produce a variety of custom reports using either Information Publisher and later the integrated BI Publisher component. The immense value of the information available in the … Read more

When the Oracle recycle bin slows down inserts

I was asked to assist in troubleshooting an interesting problem recently, and I thought it would be good to share my methodology in resolving it. There seemed to be a gradual performance degradation on one of our 12.1.0.2 systems, starting with ORA-01013 errors being reported, seeing lots of “resmgr:cpu quantum” wait events and finally bouncing … Read more

Lessons learnt working with Oracle support

This one can be a bit of a frustrating, hair pulling and (Sometimes) time consuming exercise! While I wish I could have provided you all with a silver bullet, I’m afraid it doesn’t exist, but I’d like to share some of the lessons learnt while engaging with Oracle support which may hopefully be of benefit … Read more