gdb调试之---当update时第一个持有的Latch是什么Latch锁？-mysql教程-PHP中文網

首頁

資料庫

mysql教程

gdb调试之---当update时第一个持有的Latch是什么Latch锁？

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:28 PM

gdb latch update 第一個

转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/18456937 1、查出当前会话所对应的系统进程号：SPID=7376，如下语句（在第一个窗口执行） gyj@OCM select spid from v$session s,v$process p where s.paddr=p.addr and sid in(select disti

转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/18456937

1、查出当前会话所对应的系统进程号：SPID=7376，如下语句（在第一个窗口执行）

gyj@OCM> select spid from v$session s,v$process p where s.paddr=p.addr and sid in(select distinct sid from v$mystat);

SPID
------------------------
7376

登入後複製

[oracle@mydb ~]$ gdb $ORACLE_HOME/bin/oracle 7376
GNU gdb Fedora (6.8-27.el5)
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu"...
(no debugging symbols found)
Attaching to program: /u01/app/oracle/product/11.2.0/bin/oracle, process 7376
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libodm11.so...(no debugging symbols found)...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libodm11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libcell11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libcell11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libskgxp11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libskgxp11.so
Reading symbols from /lib64/librt.so.1...done.
Loaded symbols for /lib64/librt.so.1
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libnnz11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libnnz11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libclsra11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libclsra11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libdbcfg11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libdbcfg11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libhasgen11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libhasgen11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libskgxn2.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libskgxn2.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocr11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocr11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocrb11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocrb11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocrutl11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocrutl11.so
Reading symbols from /usr/lib64/libaio.so.1...done.
Loaded symbols for /usr/lib64/libaio.so.1
Reading symbols from /lib64/libdl.so.2...done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libpthread.so.0...done.
[Thread debugging using libthread_db enabled]
[New Thread 0x2b0b8fef0910 (LWP 7376)]
Loaded symbols for /lib64/libpthread.so.0
Reading symbols from /lib64/libnsl.so.1...done.
Loaded symbols for /lib64/libnsl.so.1
Reading symbols from /lib64/libc.so.6...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/ld-linux-x86-64.so.2...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /usr/lib64/libnuma.so.1...done.
Loaded symbols for /usr/lib64/libnuma.so.1
Reading symbols from /lib64/libnss_files.so.2...done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libnque11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libnque11.so
0x0000003f0d40d290 in __read_nocancel () from /lib64/libpthread.so.0
(gdb)

登入後複製

3、设一个断点，持有第一个Latch锁(预先知道函数kslgetl就是持有Latch的函数)，并运行（c命令，即continue）（在第二个窗口执行）

(gdb) b kslgetl
Breakpoint 1 at 0x8f96376
(gdb) c
Continuing.

登入後複製

4、执行一个update语句，触发断点的操作，此时update被阻塞了（在第一个窗口执行）

gyj@OCM> update gyj_test set name=&#39;AAAAA&#39; where id=1;

登入後複製

5、一执行updater操作，断点就停在这儿了（在第二个窗口执行）

Breakpoint 1, 0x0000000008f96376 in kslgetl ()
(gdb)

登入後複製

6、我们先来看update时持有第一个Latch锁所对应函数kslgetl ()的第一个参数是什么？用命令info all-register显示寄存器（在第二个窗口执行）

(gdb) info all-register
rax            0x0      0
rbx            0x2000   8192
rcx            0xf27    3879
rdx            0x0      0
rsi            0x1      1
rdi            0x601082f0       1611694832
rbp            0x7fff1c5754d0   0x7fff1c5754d0
rsp            0x7fff1c5754d0   0x7fff1c5754d0
r8             0xf27    3879
r9             0xbaf3fa0        196034464
r10            0x0      0
r11            0xf27    3879
r12            0x927db800       2457712640
r13            0x601082f0       1611694832
r14            0x1      1
r15            0x1      1
rip            0x8f96376        0x8f96376 <kslgetl+4>
eflags         0x246    [ PF ZF IF ]
cs             0x33     51
ss             0x2b     43
ds             0x0      0
es             0x0      0
fs             0x0      0
gs             0x0      0
st0            0        (raw 0x00000000000000000000)
---Type <return> to continue, or q <return> to quit---
st1            0        (raw 0x00000000000000000000)
st2            0        (raw 0x00000000000000000000)
st3            0        (raw 0x00000000000000000000)
st4            0        (raw 0x00000000000000000000)
st5            0        (raw 0x00000000000000000000)
st6            333296   (raw 0x4011a2be000000000000)
st7            300384   (raw 0x401192ac000000000000)
fctrl          0x27f    639
fstat          0x0      0
ftag           0xffff   65535
fiseg          0x0      0
fioff          0x9394e95        154750613
foseg          0x7fff   32767
fooff          0x1c573f50       475479888
fop            0x0      0
xmm0           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm1           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm2           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm3           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x8000000000000000, 0x8000000000000000}, v16_int8 = {0xfe, 0xff, 0xff, 0xff, 
    0xff, 0xff, 0xff, 0xff, 0xfe, 0xff, 0xff, 0xff, 0xff, 0xff, 0xff, 0xff}, v8_int16 = {0xfffe, 0xffff, 0xffff, 0xffff, 0xfffe, 0xffff, 
    0xffff, 0xffff}, v4_int32 = {0xfffffffe, 0xffffffff, 0xfffffffe, 0xffffffff}, v2_int64 = {0xfffffffffffffffe, 0xfffffffffffffffe}, 
  uint128 = 0xfffffffffffffffefffffffffffffffe}
---Type <return> to continue, or q <return> to quit---
xmm4           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm5           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x32, 0xa3, 0xd7, 0x2, 0x0 <repeats 12 times>}, 
  v8_int16 = {0xa332, 0x2d7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x2d7a332, 0x0, 0x0, 0x0}, v2_int64 = {0x2d7a332, 0x0}, 
  uint128 = 0x00000000000000000000000002d7a332}
xmm6           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm7           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0xda, 0x87, 0xd7, 0x2, 0x0 <repeats 12 times>}, 
  v8_int16 = {0x87da, 0x2d7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x2d787da, 0x0, 0x0, 0x0}, v2_int64 = {0x2d787da, 0x0}, 
  uint128 = 0x00000000000000000000000002d787da}
xmm8           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm9           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm10          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm11          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm12          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x18, 0xe, 0x73, 0x90, 0xb, 0x2b, 0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v8_int16 = {0xe18, 0x9073, 0x2b0b, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x90730e18, 0x2b0b, 0x0, 0x0}, 
  v2_int64 = {0x2b0b90730e18, 0x0}, uint128 = 0x000000000000000000002b0b90730e18}
xmm13          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm14          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
---Type <return> to continue, or q <return> to quit---
xmm15          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
mxcsr          0x1fa1   [ IE PE IM DM ZM OM UM PM ]
(gdb)

登入後複製

7、rdi/edi是第一个参数， rsi/esi是第二个参数，贴出info all-register命令所显示函数kslgetl ()的两个参数，如下

8、找到第一个参数0x601082f0,注意因我的OS是64位，前面要补8个0，在v$latch_children视图中地址的字母要大写,

sys@OCM>  select  name from v$latch_children where addr=&#39;00000000601082F0&#39;;

NAME
----------------------------------------------------------------
shared pool

登入後複製

10、发现Latch锁就是shared pool Latch。

本網站聲明

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

熱AI工具

Undresser.AI Undress

人工智慧驅動的應用程序，用於創建逼真的裸體照片

AI Clothes Remover

用於從照片中去除衣服的線上人工智慧工具。

Undress AI Tool

免費脫衣圖片

Clothoff.io

AI脫衣器

Video Face Swap

使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！

熱工具

記事本++7.3.1

好用且免費的程式碼編輯器

SublimeText3漢化版

中文版，非常好用

禪工作室 13.0.1

強大的PHP整合開發環境

Dreamweaver CS6

視覺化網頁開發工具

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)

熱門話題

gmail信箱登陸入口在哪裡

7843

Java教學

1649

CakePHP 教程

1403

Laravel 教程

1300

PHP教程

1240

Related knowledge

修復：Google瀏覽器更新檢查失敗錯誤代碼3：0x80040154 Apr 13, 2023 pm 05:46 PM

谷歌瀏覽器是全球最受歡迎的瀏覽器之一，許多用戶更喜歡將其用作 Windows PC 上的預設瀏覽器。 Chrome 提供了廣泛的功能，讓瀏覽體驗愉快又輕鬆，因此，它仍然是最受信任的瀏覽器之一。但是，就像任何其他瀏覽器一樣，即使 Chrome 也有其自身的缺點，它同樣容易在您最需要的時候出現錯誤和故障。一個這樣的錯誤是錯誤代碼 3：0x80040154，這發生在檢查 Google Chrome 更新時。錯誤訊息顯示為「檢查更新時發生錯誤。更新檢查無法啟動（錯誤代碼 3：0x80080005）或（錯誤

如何啟用/停用 VS Code 自動更新 Apr 28, 2023 am 09:28 AM

如果您正在使用VisualStudioCode(VSCode)並考慮如何停用它的自動軟體更新以及如何停用其擴充功能的自動更新，那麼請閱讀本文。如果你不經常使用VSCode，隔了很長一段時間打開編輯器並想啟用自動更新，本文也將引導你這樣做。讓我們詳細討論啟用或停用VSCode自動更新的不同方法。目錄方法一：使用設定啟用/停用VSCode自動更新第一步：開啟VS代碼，在左下角點選齒輪狀的符號。步驟2：在出現的清單中點選設定。步驟3：在搜尋欄中輸入更新並回車。查找更新：模式第4

KDE Plasma 6.1 為流行的 Linux 桌面帶來了許多增強功能 Jun 23, 2024 am 07:54 AM

經過多次預發布後，KDE Plasma 開發團隊於 2 月 28 日推出了適用於 Linux 和 BSD 系統的 6.0 版桌面環境，首次使用 Qt6 框架。 KDE Plasma 6.1 現在附帶了許多新功能

Microsoft compatibility telemetry佔用高CPU的解決方法 Mar 16, 2024 pm 10:16 PM

我們在使用win10系統的時候有時候會遇到電腦變得卡頓的情況，然後我們在查看後台進程的時候會發現一個Microsoftcompatibilitytelemetry的進程佔用資源特別的高，那麼這是怎麼回事？使用者可以嘗試卸載三方防護軟體後嘗試乾淨啟動來進行操作，以下就讓本站來為使用者來仔細的介紹一下Microsoftcompatibilitytelemetry佔用高CPU的解決方法吧。 Microsoftcompatibilitytelemetry佔用高CPU的解決方法一：卸載三方防護軟體後嘗試

使用GDB調試Linux核心的常用設定技巧 Jul 05, 2023 pm 01:54 PM

使用GDB調試Linux核心的常用設定技巧引言：在Linux開發中，使用GDB調試核心是一項非常重要的技能。 GDB是一款功能強大的偵錯工具，可幫助開發者快速定位並解決核心中的bug。本文將介紹一些常用的GDB設定技巧，以及如何使用GDB來偵錯Linux核心。一、設定GDB環境首先，我們需要在Linux系統上設定GDB的環境。請確保你的系統已經安裝了GDB工具

SQL中UPDATE語句怎麼用 Jun 02, 2023 pm 09:13 PM

SQLUPDATE語句Update語句用來修改表格中的資料。語法如下：UPDATE表名稱SET列名稱=新值WHERE欄位名稱=某值"Person"表：LastNameFirstNameAddressCityGatesBillXuanwumen10BeijingWilsonChamps-Elysees更新某一行中的一個欄位UPDATEPersonSETFirstName="Fred"WHERELast="WilHER

Linux下使用GDB調試嵌入式ARM程式的常見設定方法 Jul 05, 2023 am 08:10 AM

Linux下使用GDB調試嵌入式ARM程式的常見配置方法嵌入式系統作為一種特殊的電腦系統，通常整合在電子設備中，用於控制和管理硬體資源。為了調試和分析嵌入式系統的運作狀況，我們需要使用專門的工具。其中，GDB是一種常用的開源偵錯器，它能夠在嵌入式系統上運行並與程式進行通訊。本文將介紹在Linux下使用GDB調試嵌入式ARM程式的常見配置方法，並給出程式碼範例