One of the items highlighted by the dashboard is where filesystem utilization is greater than 90% on any server where an Oracle instance is found to be running (There are various other servers maintained within the same OEM estate, so this filter was implemented to focus on the relevant hosts for the DBA team) Here … Read more
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
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
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