gdb调试之--read by other session 等待事件的重现

最新推荐文章于 2022-11-12 11:10:10 发布
最新推荐文章于 2022-11-12 11:10:10 发布
阅读量3.7k 收藏 1
点赞数 1
分类专栏： Oracle Debug
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/guoyjoe/article/details/18461845
版权

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

      发生read by other session 等待事件，肯定是两个会话同时物理读同一个数据块，假设有两个会话，会话1发生物理读，会话2正要去物理读发现会话1正在物读理产生，此时会话2发生等待，此等待就是read by other session 等待事件。


实验步骤如下：
1、开会话1，先查出会话1的进程号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


2、刷新buffer cache,目的就是让select发生物理读

gyj@OCM> alter system flush buffer_cache;

System altered.


3、通过进程号7376,打开gdb

[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)


4、在会话1，执行select语句，此时select被阻塞

gyj@OCM> select * from gyj_test where id=1;


5、在gdb设断点，用等待事件的函数，并运行

(gdb) b kslwtbctx
Breakpoint 1 at 0x8f9a5c2
(gdb) c
Continuing.


6、查等待事件kslwtbctx函数的第一个参数，用命令info all-register显示寄存器 

(gdb) info all-register
rax            0x62657100       1650815232
rbx            0x15c    348
rcx            0x0      0
rdx            0x1      1
rsi            0x7a59   31321
rdi            0x7fff1c576d40   140733668879680
rbp            0x7fff1c576ce0   0x7fff1c576ce0
rsp            0x7fff1c576ce0   0x7fff1c576ce0
r8             0x2      2
r9             0x25     37
r10            0x7      7
r11            0x0      0
r12            0x0      0
r13            0xbb0c348        196133704
r14            0xbb09d40        196123968
r15            0x1      1
rip            0x8f9a5c2        0x8f9a5c2 <kslwtbctx+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            73280    (raw 0x400f8f20000000000000)
st7            73280    (raw 0x400f8f20000000000000)
fctrl          0x27f    639
fstat          0x0      0
ftag           0xffff   65535
fiseg          0x0      0
fioff          0x9394e95        154750613
foseg          0x7fff   32767
fooff          0x1c573f50       475479888
fop            0x0      0


7、找到第一个参数
rdi            0x7fff1c576d40

8、用x/32命令查内存中32个字节

gdb) x/32 0x7fff1c576d40
0x7fff1c576d40: 0x1c577a59      0x00007fff      0x1c576e50      0x00007fff
0x7fff1c576d50: 0x1c576ee0      0x00007fff      0x0918adf2      0x00000000
0x7fff1c576d60: 0x00000000      0x00000000      0x00000000      0x00000000
0x7fff1c576d70: 0x00000000      0x00000001      0x00000000      0x00000000
0x7fff1c576d80: 0x002adb17      0x00000000      0x00000000      0x00000000
0x7fff1c576d90: 0x00000000      0x00000000      0x00000001      0x00000000
0x7fff1c576da0: 0x09b958cc      0x00000000      0x0000015c      0x00000000
0x7fff1c576db0: 0x7fffffff      0x00000000      0x62657100      0x00000000


9、找到0x0000015c，通过此等待事件号，找等待事件

gyj@OCM> select  name from v$event_name where event# in(select to_number('15c','xxxxxxxxxxxxxx') from dual);


NAME
----------------------------------------------------------------
SQL*Net message to client


10、重复第5、6、7、8、9步(注用从第5步的c命令开始） 

(gdb) c
Continuing.

Breakpoint 1, 0x0000000008f9a5c2 in kslwtbctx ()
(gdb) info all-register
rax            0x0      0
rbx            0x2000   8192
rcx            0x0      0
rdx            0x0      0
rsi            0x0      0
rdi            0x7fff1c574c38   140733668871224
rbp            0x7fff1c574970   0x7fff1c574970
rsp            0x7fff1c574970   0x7fff1c574970
r8             0x5bbb295        96187029
r9             0x2f8b5f0        49853936
r10            0x52da848e       1390052494
r11            0x2b0b9057e7a8   47328666314664
r12            0x99837da8       2575531432
r13            0x0      0
r14            0x0      0
r15            0x99437498       2571334808
rip            0x8f9a5c2        0x8f9a5c2 <kslwtbctx+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            73280    (raw 0x400f8f20000000000000)
st7            73280    (raw 0x400f8f20000000000000)
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 = {0x0, 0x0}, v16_int8 = {0x0, 0x0, 0x0, 0x0, 0x54, 0x3, 0x1, 0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0, 0x0}, v8_int16 = {0x0, 0x0, 0x354, 0x1, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x10354, 0x0, 0x0}, v2_int64 = {
    0x1035400000000, 0x0}, uint128 = 0x00000000000000000001035400000000}
xmm4           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x64, 0x0 <repeats 15 times>}, v8_int16 = {0x64, 0x0, 
---Type <return> to continue, or q <return> to quit---
    0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x64, 0x0, 0x0, 0x0}, v2_int64 = {0x64, 0x0}, uint128 = 0x00000000000000000000000000000064}
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}
xmm15          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 <repeats 16 times>}, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
---Type <return> to continue, or q <return> to quit---
    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) 
(gdb) x/32 0x7fff1c574c38
0x7fff1c574c38: 0x08f97a59      0x00000000      0x9079c6d8      0x00002b0b
0x7fff1c574c48: 0x90742970      0x00002b0b      0x9079c748      0x00002b0b
0x7fff1c574c58: 0x1c574df0      0x00007fff      0x9079c748      0x00002b0b
0x7fff1c574c68: 0x9079c6d8      0x00002b0b      0x00000000      0x00000000
0x7fff1c574c78: 0x00000000      0x00000000      0x00000013      0x20000000
0x7fff1c574c88: 0x00000000      0x00000000      0x00000001      0x00000000
0x7fff1c574c98: 0x0a0fcd50      0x00000000      0x00000092      0x00000000
0x7fff1c574ca8: 0x7fffffff      0x00000000      0x00000006      0x00000000
(gdb)



11、找到0x00000092，通过此等待事件号，找等待事件0x00000092 

gyj@OCM> gyj@OCM> select  name from v$event_name where event# in(select to_number('92','xxxxxxxxxxxxxx') from dual);


NAME
----------------------------------------------------------------
db file sequential read

说明此时会话1发生了物理读（db file sequential read等待事件你懂我）



12、打开会话2（此会话2号的SID=146）,并在会话2执行SELECT语句，此时SELECT也被阻塞了

gyj@OCM> select sid from v$mystat where rownum=1;

       SID
----------
       146

 gyj@OCM> select * from gyj_test where id=1;


13、打开一个会话3，看会话2（此会话2号的SID=146）的等待事件 

sys@OCM> select sid ,event from v$session_wait where sid=146 and wait_class<>'Idle';

       SID EVENT
---------- ----------------------------------------------------------------
       146 read by other session


哈哈。。。终于发现了read by other session等待事件，以后可以用同样的方法去研究其它等待事件！


QQ：252803295

技术交流QQ群：
DSI&Core Search  Ⅰ 群：127149411（2000人技术群:未满）
DSI&Core Search  Ⅱ 群：177089463（1000人技术群:未满）
DSI&Core Search  Ⅲ 群：284596437（500人技术群:未满）
DSI&Core Search  Ⅳ 群：192136702（500人技术群:未满）
DSI&Core Search  Ⅴ 群：285030382（500人闲聊群:未满）


MAIL：dbathink@hotmail.com

BLOG： http://blog.csdn.net/guoyjoe

WEIBO：http://weibo.com/guoyJoe0218

ITPUB： http://www.itpub.net/space-uid-28460966.html

OCM：   http://education.oracle.com/education/otn/YGuo.HTM 

ACONG:  http://www.acoug.org/category/membership



郭一军_guoyJoe
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
0x00007FF8EDA19A9D (ntdll.dll)处引发的异常: 0xC0000005: 写入位置 0x00000000CED889F8 时发生访问冲突
jacke121的专栏
04-30 1万+
0x00007FF8EDA19A9D (ntdll.dll)处引发的异常: 0xC0000005: 写入位置 0x00000000CED889F8 时发生访问冲突 这个错误代码： EnterCriticalSection(&g_cs); queue1.push(recvp);// recvp); LeaveCriticalSection(&...
GDB调试--以汇编语言为例
10-22
GDB调试--以汇编语言为例
内核漏洞进击之旅——Dark Composition Exploitation Case Study
qq_36606493的博客
10-12 1267
作者：k0shl 0x00 前言 尝试写这个 Exploit 的起因是邱神 @pgboy1988 在3月份的一条微博，这是邱神和社哥在 cansecwest2017上的议题《Win32k Dark Composition－－Attacking the Shadow Part of Graphic Subsystem》，后来邱神在微博公开了这个议题的 slide，以及议题中两个 demo
hello怪折腾的一生——csapp大作业
qq_52019899的博客
05-10 1046
第1章 概述 1.1 Hello简介 （1）P2P简介 用户通过编辑器编写代码，得到hello.c（Program）源程序。在Linux 操作系统下，通过调用C预处理器将.c文件预处理生成中间文件hello.i。再通过编译器将hello.s文件翻译为汇编语言文件hello.s。然后运行汇编器 得到可重定位目标文件hello.o。最后通过链接器得到可执行目标文件 hello。当我们在shell命令行中输入./hello后，shell将其解析为可执行文件， 然后调用fork函数为其产生子进程，在子进程中运
ctf夺旗赛
m0_63017769的博客
11-12 5061
好久以前做过的ctf
第19部分- Linux x86 64位汇编GDB单步调试
badman250的专栏
05-23 911
第19部分- Linux x86 64位汇编GDB单步调试 本篇我们使用gdb来调试上篇中的汇编代码。 gdb调试 使用gdb进行调试。 #gdb ./addsum_arg 设置参数: (gdb) set args 1 1 #启动程序 (gdb) r #查看寄存器 (gdb) i r rcx 可以看到启动进程时候rcs为0. 查看rsp寄存器对应的地址. (gdb) i r rsp rsp 0x7fffffffe3d0 0x7fffffffe3d...
gdb调试-这些就够了.pdf
04-11
是不是有以下困惑： （1）gdb不是好用，不能很好辅助你调试； 多半是你对gdb的学习还不够深。 （2）用了很久的gdb感觉还是...关键词： gdb，调试，gdb调试，编译，gdb教程，gdb手册，gcc，c调试，c++调试，gdb用户手册
QT程序调试器——qtcreator-gdb-7.4-MINGW32_NT-6.1-i686
03-23
qtcreator-gdb-7.4-MINGW32_NT-6.1-i686版本调试器主要用于调试QT程序，与QT4.8.5桌面版配套，在本博客内也有相关资源可以下载。
gdb_8.2.1-2+b3_amd64.deb
08-07
gdb_8.2.1-2+b3_amd64.deb
gdb.rar_gdb_gdb-6.6
09-23
gdb指南，是linux下的一个调试器，非常强大和有用，这是一个快速入门的指南。
oracle 启动_oracle实验--通过gdb工具研究数据库启动过程
weixin_39766109的博客
12-06 276
概述分享下之前做的一个小实验，通过gdb工具来研究下oracle数据库启动过程。1、启动数据库到mount状态并获取进程spidstartup mount;select spid from v$process where addr in (select paddr from v$session where sid=(select distinct sid from v$mystat));这里注意窗...
ORACLE等待事件：read by other session
weixin_30770783的博客
06-26 4250
read by other session简介 官方关于read by other session的介绍如下： When information is requested from the database, Oracle will first read the data from disk into the database buffer cache. If two or more se...
Oracle when other,学习笔记:Oracle等待事件 Read by other session产生原因和解决办法
weixin_42502775的博客
04-02 442
天萃荷净运维DBA在巡检Oracle时发现Read by other session等待事件，分析原因为查询报表导致今天中午发现福建生产库报负载有点异常，处理思路记录下来：1、使用top命令查看系统，发现系统负载是比以前要搞(平时都是1以下，今天已经稳定在4左右，总是有部分进城占用cpu比较高，系统cpu等待明显)1.1)第一反应是有人执行sql导致，抓取占用cpu较高的spid，查询出对应sql...
oracle read by other session,read by other session等待事件
weixin_35304632的博客
04-14 207
read by other session发生的场景：当查询数据时，Oracle要把block从硬盘读到buffer cache中。如果有两个或更多session同时读取同一个block数据，第一个session会将block读取到buffer cache，由于block尚未完全读取到buffer cache，就导致其他session处于"read by other session"等待下。这个是...
oracle read by other session,AWR报告中，read by other session等待占88％，如何解决？
weixin_32321921的博客
04-14 123
AWR报告中，read by other session等待占88％，如何解决？中文社区 (MOSC)数据库 (MOSC)3 RepliesLast updated on March 07, 2013This question is Not Answered.ORACLE版本10.2.0.4.0分析数据库AWR报告，Top 5 Timed Events 中，read...
gdb导入oracle,gdb跟踪oracle内部函数调用
weixin_29138345的博客
04-06 392
linux版本[oracle@ykcdb01 ~]$ lsb_release -aLSB Version: :core-3.0-amd64:core-3.0-ia32:core-3.0-noarch:graphics-3.0-amd64:graphics-3.0-ia32:graphics-3.0-noarchDistributor ID: RedHatEnterpriseASDescrip...
反调试 - TrapFlag
LYSM
07-13 844
原理 TrapFlag（陷阱标志位）。这种反调试手段属于异常的范畴，通过设置 eflags 寄存器的值来触发某个异常，当存在调试器时这个异常由调试器接管（不走我们 的异常处理回调函数），但调试器也可以选择不接管这个异常，所以这属于一种低级的反调试手段 ????。 代码（以单步异常为例） // Test_Console_1.cpp : 此文件包含 "main" 函数。程序执行将在此处开始并结束。 // #include <iostream> #include <Windows.h>
怎样用调试工具gdb Dump Oracle系统状态
u010692693的专栏
05-05 1110
本文转自 老熊的三分地，文章链接是http://www.laoxiong.net/how_debugger_dump_oracle_state.html，在此表示感谢   如果Oracle数据库hang住了，对Oracle做system dump，或做hang analyze，是研究和解决问题的有效办法，至少在提交SR时能够有更多的有用信息。如果能够连接数据库，并能够进行操作，那么用orade
gdb调试gpgpu-sim
最新发布
08-24
您好！对于使用gdb调试gpgpu-sim，您可以按照以下步骤进行操作： 1. 在编译gpgpu-sim时，确保启用了调试信息。通过在编译选项中添加`-g`选项来实现。例如： ```shell $ make COPTFLAGS=-g ``` 2. 运行gpgpu-sim，并在gdb中附加到进程。首先，在一个终端窗口中启动gpgpu-sim： ```shell $ ./gpgpu-sim --config <config_file> ``` 然后，打开另一个终端窗口，并使用以下命令附加到正在运行的进程： ```shell $ gdb -p <pid> ``` 其中，`<pid>`是gpgpu-sim进程的PID。 3. 在gdb中设置断点。可以使用`break`命令在代码中设置断点，例如： ```shell (gdb) break main.cpp:42 ``` 这将在`main.cpp`文件的第42行设置一个断点。 4. 执行调试操作。使用`run`命令开始执行程序，例如： ```shell (gdb) run ``` 当程序达到断点时，调试会停止，并且您可以通过使用`print`命令查看变量的值，使用`step`命令逐步执行代码，或使用其他gdb命令进行调试。 希望这些步骤对您有所帮助！如果您有任何进一步的问题，请随时提问。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值