orawin.info

By way of an answer to a question on Oracle-l regarding how to intepret a 10053 trace file, I posted a link to one of a new series of articles available on Oracle’s Metalink service. I think it worth mentioning these articles here as well, as I haven’t seen any publicity for them.

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

Possibly Related Posts:

• No Related Posts found