Friday, January 13, 2006
New Resources on Metalink
Oracle's Center of Expertise (COE) have put together a number (5 at the time of writing) of case studies from Oracle support. These are best accessed through metalink by selecting the knowledge tab and then support case studies from the support tools menu. Each case study details an actual support call complete with the diagnostic and troubleshooting steps the analysts took. The case studies appear to have been written primarily as a knowledge sharing tool within Oracle corp, but provide a good guide for customers for troubleshooting various issues.
As well as the 10053 example the current range includes the following support cases
Disappearing OCFS drives on windows
Slow client connections to RAC
Troubleshooting a slow query (including tkprof, event 10046 and so on)
Troubleshooting random buffer busy waits
The other encouraging factor for me is that Oracle are actively seeking suggestions for further topics for case studies, and that they appear to have at least a tentative publication schedule (the next set is due March 2006).
Update: 16 January 2006. Changed Centre of Excellence to Center of Expertise because that is the correct name. Thanks Roderick