Oracle 运维篇+进程追踪调试（Linux系统）

最新推荐文章于 2023-11-27 18:31:15 发布
原创 最新推荐文章于 2023-11-27 18:31:15 发布 · 726 阅读 · 0 ·
CC 4.0 BY-SA版权
本文作者：zzt_2009
文章标签：

#strace #进程追踪 #进程调试 #Oracle进程追踪调试

本文详细介绍如何使用strace命令对Linux下Oracle进程进行追踪调试。strace作为强大的诊断工具，能够帮助定位Oracle进程中的异常问题，文章包括strace的介绍、在Oracle中的应用、常用语法、推荐文章及调试实例。

说明：本文为Linux下Oracle进程追踪调试指导手册，
标签：strace、进程追踪、进程调试、Oracle进程追踪调试
温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化

正文开始

大纲

--strace介绍
--在Oracle中的用途
--语法
--推荐网文
--命令样例
--输出日志

 

★ strace介绍
/////////////////////////////////////
strace命令是一个集诊断、调试、统计与一体的工具，它像是一个侦探，通过系统调用的蛛丝马迹，告诉你异常的真相。

★ 在Oracle中的用途
/////////////////////////////////////
当Oracle部分进程异常时，可以使用该命令对相关进程追踪查看并调试，从而找到并解决问题

★ 语法
/////////////////////////////////////
语法详情：一般Linux都会自带该工具，您可以使用MAN命令来获取该命令的帮助详情
常用语法：strace -o LOGFILE  COMMAND（需要跟踪的命令）
常用语法：strace -o LOGFILE  -p nnn（需要跟踪的进程PID）

★ 推荐网文
/////////////////////////////////////
ljy_home写的《Linux之strace简单用法》：https://blog.youkuaiyun.com/ljy_home/article/details/51941283

★ Oracle的调试命令样例
/////////////////////////////////////
strace -t -o /home/oracle/s.log  sqlplus / as sysdba

★ 输出日志
/////////////////////////////////////

10:33:42 execve("/u01/app/oracle/product/11.2.0/db_1/bin/sqlplus", ["sqlplus", "/", "as", "sysdba"], [/* 34 vars */]) = 0
10:33:42 brk(0)                         = 0xee8000
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe445ead000
10:33:42 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/tls/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 stat("/u01/app/oracle/product/11.2.0/db_1/lib/tls/x86_64", 0x7fff8345c9b0) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/tls/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 stat("/u01/app/oracle/product/11.2.0/db_1/lib/tls", 0x7fff8345c9b0) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 stat("/u01/app/oracle/product/11.2.0/db_1/lib/x86_64", 0x7fff8345c9b0) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0@\370\1\0\0\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0644, st_size=1469542, ...}) = 0
10:33:42 mmap(NULL, 1985056, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe445cc8000
10:33:42 mprotect(0x7fe445d9e000, 1048576, PROT_NONE) = 0
10:33:42 mmap(0x7fe445e9e000, 57344, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd6000) = 0x7fe445e9e000
10:33:42 mmap(0x7fe445eac000, 2592, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe445eac000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\326G\0\0\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=53793730, ...}) = 0
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe445cc7000
10:33:42 mmap(NULL, 44472168, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe44325d000
10:33:42 mprotect(0x7fe4458db000, 2093056, PROT_NONE) = 0
10:33:42 mmap(0x7fe445ada000, 1855488, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x267d000) = 0x7fe445ada000
10:33:42 mmap(0x7fe445c9f000, 161640, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe445c9f000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.so", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\326\4\0\0\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0644, st_size=7996693, ...}) = 0
10:33:42 mmap(NULL, 3983936, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe442e90000
10:33:42 mprotect(0x7fe44311a000, 1044480, PROT_NONE) = 0
10:33:42 mmap(0x7fe443219000, 270336, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x289000) = 0x7fe443219000
10:33:42 mmap(0x7fe44325b000, 6720, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe44325b000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("libdl.so.2", O_RDONLY)   = -1 ENOENT (No such file or directory)
10:33:42 open("/etc/ld.so.cache", O_RDONLY) = 3
10:33:42 fstat(3, {st_mode=S_IFREG|0644, st_size=116273, ...}) = 0
10:33:42 mmap(NULL, 116273, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fe442e73000
10:33:42 close(3)                       = 0
10:33:42 open("/lib64/libdl.so.2", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\r@\31:\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=22536, ...}) = 0
10:33:42 mmap(0x3a19400000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a19400000
10:33:42 mprotect(0x3a19402000, 2097152, PROT_NONE) = 0
10:33:42 mmap(0x3a19602000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3a19602000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/x86_64/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("x86_64/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("libm.so.6", O_RDONLY)    = -1 ENOENT (No such file or directory)
10:33:42 open("/lib64/libm.so.6", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240>\300\31:\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=598800, ...}) = 0
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe442e72000
10:33:42 mmap(0x3a19c00000, 2633944, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a19c00000
10:33:42 mprotect(0x3a19c83000, 2093056, PROT_NONE) = 0
10:33:42 mmap(0x3a19e82000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x82000) = 0x3a19e82000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/x86_64/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("x86_64/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/lib64/libpthread.so.0", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`\\\0\32:\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=145720, ...}) = 0
10:33:42 mmap(0x3a1a000000, 2212768, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a1a000000
10:33:42 mprotect(0x3a1a017000, 2097152, PROT_NONE) = 0
10:33:42 mmap(0x3a1a217000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x3a1a217000
10:33:42 mmap(0x3a1a219000, 13216, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a1a219000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/x86_64/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("x86_64/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("libnsl.so.1", O_RDONLY)  = -1 ENOENT (No such file or directory)
10:33:42 open("/lib64/libnsl.so.1", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p@\300*:\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=116368, ...}) = 0
10:33:42 mmap(0x3a2ac00000, 2198192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a2ac00000
10:33:42 mprotect(0x3a2ac16000, 2093056, PROT_NONE) = 0
10:33:42 mmap(0x3a2ae15000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3a2ae15000
10:33:42 mmap(0x3a2ae17000, 6832, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a2ae17000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/x86_64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("x86_64/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("libc.so.6", O_RDONLY)    = -1 ENOENT (No such file or directory)
10:33:42 open("/lib64/libc.so.6", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360\355\201\31:\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=1918016, ...}) = 0
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe442e71000
10:33:42 mmap(0x3a19800000, 3741864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3a19800000
10:33:42 mprotect(0x3a19989000, 2093056, PROT_NONE) = 0
10:33:42 mmap(0x3a19b88000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x188000) = 0x3a19b88000
10:33:42 mmap(0x3a19b8d000, 18600, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3a19b8d000
10:33:42 close(3)                       = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/x86_64/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("tls/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("x86_64/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
10:33:42 open("libaio.so.1", O_RDONLY)  = -1 ENOENT (No such file or directory)
10:33:42 open("/lib64/libaio.so.1", O_RDONLY) = 3
10:33:42 read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\5@\31:\0\0\0"..., 832) = 832
10:33:42 fstat(3, {st_mode=S_IFREG|0755, st_size=5624, ...}) = 0
10:33:42 mmap(0x3a19400000, 2099840, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe442c70000
10:33:42 mprotect(0x7fe442c71000, 2093056, PROT_NONE) = 0
10:33:42 mmap(0x7fe442e70000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0) = 0x7fe442e70000
10:33:42 close(3)                       = 0
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe442c6f000
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe442c6e000
10:33:42 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe442c6d000
10:33:42 arch_prctl(ARCH_SET_FS, 0x7fe442c6e700) = 0
10:33:42 mprotect(0x3a19b88000, 16384, PROT_READ) = 0
10:33:42 mprotect(0x3a2ae15000, 4096, PROT_READ) = 0
10:33:42 mprotect(0x3a1a217000, 4096, PROT_READ) = 0
10:33:42 mprotect(0x3a19e82000, 4096, PROT_READ) = 0
10:33:42 mprotect(0x3a19602000, 4096, PROT_READ) = 0
10:33:42 mprotect(0x3a1921f000, 4096, PROT_READ) = 0
10:33:42 munmap(0x7fe442e73000, 116273) = 0
10:33:42 set_tid_address(0x7fe442c6e9d0) = 9729
10:33:42 set_robust_list(0x7fe442c6e9e0, 0x18) = 0
10:33:42 futex(0x7fff8345d2bc, FUTEX_WAKE_PRIVATE, 1) = 0
10:33:42 futex(0x7fff8345d2bc, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7fe442c6e700) = -1 EAGAIN (Resource temporarily unavailable)
10:33:42 rt_sigaction(SIGRTMIN, {0x3a1a005ae0, [], SA_RESTORER|SA_SIGINFO, 0x3a1a00f500}, NULL, 8) = 0
10:33:42 rt_sigaction(SIGRT_1, {0x3a1a005b70, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3a1a00f500}, NULL, 8) = 0
10:33:42 rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
10:33:42 getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0
10:33:42 brk(0)                         = 0xee8000
10:33:42 brk(0xf09000)                  = 0xf09000
10:33:42 rt_sigaction(SIGQUIT, {0x7fe445d70d14, [QUIT], SA_RESTORER|SA_RESTART, 0x3a19832920}, {SIG_DFL, [], 0}, 8) = 0
10:33:42 rt_sigaction(SIGABRT, {0x7fe445d70d14, [ABRT], SA_RESTORER|SA_RESTART, 0x3a19832920}, {SIG_DFL, [], 0}, 8) = 0
10:33:42 mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe442c4a000
10:33:42 futex(0x3a196030ec, FUTEX_WAKE_PRIVATE, 2147483647) = 0
10:33:42 open("/u01/app/oracle/product/11.2.0/db_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No suc
最低0.47元/天 解锁文章
网络安全从入门到精通（特别篇I）：Linux安全事件应急响应之Linux应急响应基础必备技能
HACKONE的博客
04-10 1843
awk 首先将每条日志中的IP抓出来，如日志格式被自定义过，可以 -F 定义分隔符和 print指定列；
trace跟踪
weixin_34110749的博客
02-28 851
strace命令是一个集诊断、调试、统计与一体的工具，我们可以使用strace对应用的系统调用和信号传递的跟踪结果来对应用进行分析，以达到解决问题或者是了解应用工作过程的目的。当然strace与专业的调试工具比如说gdb之类的是没法相比的，因为它不是一个专业的调试器。strace的最简单的用法就是执行一个指定的命令，在指定的命令结束之后它也就退出了。在命令执行的过程中，str...
Oracle 进程追踪调试（Linux系统）
01-09
说明：本文为Linux下Oracle进程追踪调试指导手册， 标签：strace、进程追踪、进程调试、Oracle进程追踪调试 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 正文开始 大纲 –strace介绍 –在Oracle中的用途 –语法 –推荐网文 –命令样例 –输出日志 ★ strace介绍 ///////////////////////////////////// strace命令是一个集诊断、调试、统计与一体的工具，它像是一个侦探，通过系统调用的蛛丝马迹，告诉你异常的真相。 ★ 在Oracle中的用途 ///////////////////////
Oracle用户进程跟踪
weixin_33786077的博客
08-11 235
用户进程跟踪 1 分为 基于会话级别跟踪和 实例级别跟踪； 2 会话级别跟踪又包括 当前会话跟踪和 非当前会话跟踪 3 跟踪文件位置由user_dump_dest设定，大小由max_dump_file_size 决定 4 生成的跟踪文件名为<SID>_ora_<SPID>.trc 其中SID为实例名称，SPID为系统进程号 5 通过v$session中的SQ...
linux下oracle调试小知识
weixin_30571465的博客
07-04 157
1、oracle 安装下的/u01/diag/rdbms/orcl/HOF/incident目录下是什么文件？答：每当一个错误发生的时候，oracle会创建一个incident，并且分配一个INCIDENT_ID号，同时在ADR HOME的INCIDENT目录中创建相应的INCIDENT 目录，每个错误号一个INCIDENT目录，目录被命名为incdir_<INCIDENT_ID&...
使用SQL_TRACE进行数据库诊断
cimingjiao2938的博客
05-19 364
作者：eygle | English Version 【转载时请以超链接形式标明文章出处和作者信息及本声明】链接：http://www.eygle.com/archives/2004/10/use_sql_trace_to_di...
深入了解Oracle跟踪事件:set events
conger3400的博客
08-20 175
一、Oracle跟踪文件 Oracle跟踪文件分为三种类型，一种是后台报警日志文件，记录数据库在启动、关闭和运行期间后台进程的活动情况,如表空间创建、回滚段创建、某些alter命令、日志切换、错误消息等。在数据...
开源运维监控系统-Nightingale（夜莺）应用实践
企业实战系列集 ●●● https://ximenjianxue.blog.youkuaiyun.com
11-27 4810
某业务系统因OS改造，原先的Zabbix监控系统推倒后未重建，本来计划用外部企业内其他监控系统接入，后又通知需要自建才能对接，考虑之前zabbix的一些不便，本次计划采用一个类Prometheus的监控系统，镜调研后发现Nightingale兼容Prometheus，又有一些其他功能增强，又在一些大的企业经过较大规模部署实践，故本次采用Nightingale作为监控系统来进行重建。
基于crontab实现Linux与Oracle运行状态监控
使用crontab检测Linux和Oracle运行是否正常，是一种在企业级IT运维中非常常见且高效的系统与数据库健康状态监控方案。该方法结合了Linux系统的定时任务调度工具crontab与自动化脚本技术，实现对服务器操作系统及关键...
Linux操作系统之—所有端口详解大全手册
Jay
12-23 2522
LINUX端口详解大全 0|无效端口,通常用于分析操作系统 1|传输控制协议端口服务多路开关选择器 2|管理实用程序 3|压缩进程 5|远程作业登录 7|回显 9|丢弃 11|在线用户 13|时间 17|每日引用 18|消息发送协议 19|字符发生器 20|FTP文件传输协议(默认数据口)　 21|FTP文件传输协议(控制) 22|SSH远程登录协议 23|telnet(终端仿真协议),木马Tiny Telnet Server开放此端口 24|预留给个人用邮件系统 25|...
OraTracer-进程跟踪工具
08-17
OraTracer-进程跟踪工具，适合windows平台使用，分析进程。
使用Linux Strace跟踪调试Oracle程序进程
ciqu9915的博客
06-17 296
所谓操作系统，是应用程序与服务器硬件进行沟通的中间层。应用程序的所有操作，都是和操作系统进行沟通交互。操作系统负责将所有交互转化为设备语言，进行硬件交互。 我们在进行Oracle故障调试和内核...
strace命令_详解Linux strace工具--使用strace窥视Oracle LGWR进程
weixin_39628380的博客
12-10 376
概述strace一般用来跟踪系统调用和信号量，是一个很好的诊断、排错的工具。每行输出都是一个系统调用，包括函数和返回值。常用参数-c 统计每一系统调用的所执行的时间,次数和出错的次数等. -d 输出strace关于标准错误的调试信息. -f 跟踪由fork调用所产生的子进程. -ff 如果提供-o filename,则所有进程的跟踪结果输出到相应的filename.pid中,pid是各进程的进程号...
oracle trace进程,ORACLE SQL_TRACE的使用
weixin_35625324的博客
04-03 369
“SQL TRACE”是Oracle提供的用于进行SQL跟踪的手段，是强有力的辅助诊断工具。在日常的数据库问题诊断和解决中，“SQL TRACE”是非常常用的方法。一般，一次跟踪可以分为以下几步：1、界定需要跟踪的目标范围，并使用适当的命令启用所需跟踪。2、经过一段时间后，停止跟踪。此时应该产生了一个跟踪结果文件。3、找到跟踪文件，并对其进行格式化，然后阅读或分析。本文就“SQL TRACE”的这...
oracle 怎么使用跟踪,Oracle 10046跟踪事件使用方法
weixin_33525298的博客
04-12 1191
1.开启10046跟踪事件alter session set events '10046 trace name context forever, level 12';如果想更容易标识trace文件，在开启事件之前，可以先设置trace的标识alter session set tracefile_identifier='ybb';这样完成后，trace文件名称就会加上ybb2.执行要跟踪的sql语句...
oracle 跟踪工具 知乎,在Oracle中跟踪后台所执行的SQL语句
weixin_35057726的博客
04-14 834
分享2015-12-02在oracle中可以跟踪后台所执行的sql，具体有以下两种设置方法:在实际排查问题的过程中，尤其是在前端应用已经报出ORA错误的时候用此方法非常奏效，在前几章排查问题的过程中我也多次使用了该方法。以下是设置跟踪的方法。一.在系统级别上设置sql跟踪该方法优点:可以跟踪所有的oracle的后台进程所执行的sql,包括系统后台进程和用户进程,并且可以跟踪所有的操作 ...
以Lgwr Worker为例,基于Strace 分析 Oracle 数据库行为的方法
Free雅轩的博客
09-18 503
在缺乏必要的资料，甚至连一个METALINK账号都没有的时期，学习Oracle数据字典的基本原理，以及数据库启动时的主要动作等，都是通过10046 trace文件完成的。前两天研究了一下Oracle的LGWR worker新机制，我后来也问了一些客户，在一些系统规模不是很大的场景，好像客户都没有感受到这个新的变化。因为10046中会输出某个会话执行过的SQL语句，产生过的各种等待事件，利用这个TRACE上的时间戳，结合strace对于调用堆栈的跟踪，就很容易进行问题定位了。我们来看看这个完整的过程。
oracle 11.2g,Oracle Linux内核上的Oracle11.2g安装后问题
weixin_29358053的博客
04-03 237
在Oracle Linux内核上以静默方式安装Oracle 11.2g后,出现以下错误：[u01/app/oracle/product/11/bin] $sqlplussqlplus error while loading shared libraries: libsqlplus.so: cannot open sharedobject file: No such file or director...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值