P112 RDBMS Forensics: Troubleshooting Using ASH by Tim Gorman

Date & Time

Mar 13th at 6:00 PM until 6:45 PM

Track

Core Tech 

Location

Rating ( votes)

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

But it is not art, it is process, and the intent of this presentation is to use two case studies, each resolving the 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 vital and important 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.