"오라클 덤프 oradebug"의 두 판 사이의 차이

DB CAFE

2024년 4월 28일 (일) 18:33 판

추천메뉴 바로가기

DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
튜닝 { 오라클 튜닝 목록 }
모델링 { 데이터 모델링 가이드 }

-- oracle process attach select prc.pid

 from v$bgprocess bgp
    , v$process prc 
where bgp.name = 'LGWR'
  and prc.addr = bgp.paddr

PID

SQL> oradebug setorapid 20 Oracle pid: 20, Unix process pid: 2977, image: oracle@b4eb0743df57 (LGWR)

-- suspend oradebug suspend

-- 다른 세션에서 sql 을 수행하고 commit 을 수행함. -- commit 작업은 hang에 걸리게 됨. log file sync 대기이벤트를 대기 하게 됨.

-- resume oradebug resume

SQL> oradebug tracefile_name /u01/app/oracle/diag/rdbms/mongo/MONGO/trace/MONGO_ora_30886_DBCAFE.trc SQL> SQL> SQL> oradebug dumpvar sga kcbnhb ORA-00079: variable kcbnhb not found SQL> SQL> SQL> oradebug dumpvar sga kcbnhb ORA-00079: variable kcbnhb not found SQL> SQL> SQL> oradebug setmypid Statement processed. SQL> oradebug dumpvar sga kcbnhb ORA-00079: variable kcbnhb not found SQL> SQL> alter session set use_stored_outlines = rule_based;

Session altered.

SQL> oradebug setmypid Statement processed. SQL> oradebug dumpvar uga ugauso_p qolprm ugauso_p [7F197A4EFC48, 7F197A4EFCD0) = 00000001 5552000A 425F454C 44455341 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ...

SGA내 변수 찾기 - x$ksmfsv (Kernel Services Memory Fiexed SGA Variables )[편집]

SQL> select ksmfsnam from x$ksmfsv where ksmfsnam like 'kcbn%'

 2  ;

KSMFSNAM

kcbncbh_ kcbnwp_ kcbnbf_ kcbnpg_ kcbnchkl_ kcbnchk_ kcbnumaactive_ kcbnvmenabled_ kcbnbcscv_

9 rows selected.

@@ 50번째 줄: / 50번째 줄: @@
 qolprm ugauso_p [7F197A4EFC48, 7F197A4EFCD0) = 00000001 5552000A 425F454C 44455341 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 ...
+=== SGA내 변수 찾기 - x$ksmfsv (Kernel Services Memory Fiexed SGA Variables ) ===
+<source lang=sql>
 SQL> select ksmfsnam from x$ksmfsv where ksmfsnam like 'kcbn%'