如何使用hanganalyze解释trace介绍.pdfVIP

HowtouseHANGANALYZEandHowto

InterpretingHANGANALYZEtracefile

Kamus@EnmoTech

Wednesday,March14,12

Howto-SingleNode

•sqlplus/assysdba

•oradebugsetmypid

•oradebugunlimit;

•oradebughanganalyze3

•...waitatleast1minute

•oradebughanganalyze3

Wednesday,March14,12

Howto-RAC

•sqlplus/assysdba

•oradebugsetmypid

•oradebugunlimit;

•oradebugsetinstall

•oradebug-gdefhanganalyze3

•...waitatleast1minute

•oradebug-gdefhanganalyze3

Wednesday,March14,12

Howto-UsingHANGFG

•MOSNote:362094.1

•RACaware

•hangfg.sh1|2|3

•defaultvalueis2

•1ismostlightimpact,hanganalyzelevel3

•3ismostheavyimpact,hanganalyzelevel4

•makesureyouhave“compress”cmd

•ln-s/bin/gzip/bin/compress

Wednesday,March14,12

Howto-Ifcan’tlogin

•MOSNote:121779.1

•sqlplus-prelim/assysdba

•FromOracle10gandHigher

•Nosessioncreated,butlimitedaccess

totheSGA

Wednesday,March14,12

Howto-Ifcan’tlogin

•MOSNote:121779.1

•dbx

•Oracle9iandearlier

•Sourceleveldebug

•Solaris,Linux

Wednesday,March14,12

dbx

$ps-ef|grepLOCAL

ora10g282971013:58?00:00:00oracleORCL(LOCAL=NO)

$whichdbx

/opt/oracle/solarisstudio12.3/bin/dbx

$dbx

(dbx)attach28297

(dbx)printksdhng(3,1,0)***oradebughanganalyze3

(dbx)printksudss(10