But it is not art, it is process, and the intent of this presentation is to use a case study (i.e. resolving ORA-03136 connection lost error) to demonstrate that process, and also to show how components such as AWR and ASH, typically thought of as performance tuning tools, are also useful diagnostic tools.