Hotsos Symposium Speaker – Tim Gorman

Tim Gorman is a returning Hotsos Symposium presenter.


Tim GormanTim Gorman began his IT career in 1984 as a "C" programmer on UNIX and VMS systems, and now focuses on performance tuning applications, databases, and systems, as well as data warehouse design and implementation, database backup and recovery, architecture and infrastructure, and database administration.

Mr. Gorman co-founded Evergreen Database Technologies, Inc. and is widely recognized as an expert in tuning and trouble-shooting advanced technology, large-scale, highly-complex, secured systems. Tim co-authored Expert Oracle Practices — Database Administration from the OakTable (Dec 2009, published by Apress) and Oracle Insights — Tales of the OakTable (July 2004, published by Apress).

Tim is an Oracle Ace.

Presentation Title

Forensic Analysis using AWR and ASH


Arthur C. Clarke wrote that "any sufficiently advanced technology is indistinguishable from magic". This has been proven true, and it makes troubleshooting of that technology seems like art.

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.

Attendees to this presentation will learn a forensic, empirical approach to trouble-shooting and also see a demonstration of a complex troubleshooting task following a non-intuitive but empirically sound resolution.

Presentation Materials

Presentation materials are available online to attendees only.


The speaker schedule is as follows: