ITPUB

Oct 17, 2016 · Databases

Quickly Diagnose Oracle Lock Contention with AWK and ass109.awk

This guide demonstrates how to use the ass109.awk script and Oracle's oradebug tool to capture, parse, and analyze trace files, quickly identifying lock and deadlock sessions in Oracle 11gR2 without resorting to costly restarts.