有没有什么工具可以监控oracle数据库里数据的变化

如果是C-S的系统,推荐TOAD--sql-monitor,可以跟踪到客户端所有发起的数据库 *** 作很强大特别对于排错

如果是只是需要查看特别对象的变化话,没有这么针对性强的东西,除非你们自己编写一个 不过,可以使用TOAD或者其它可视化工具进行查看有"刷新"按钮的

哦,看来我理解错了你是说要看整个数据库资源的情况么这个工具里面有现成的,可以自动定时刷新当然也可以看日志 也可以从当前 *** 作系统提供的命令来辅助查看

1 sar

每两秒刷新一次， 总共5次

[root@dbhost01 ~]# sar 2 5

Linux 2632-504el6x86_64 (dbhost01) 03/30/2018 _x86_64_ (4 CPU)

02:53:15 PM CPU %user %nice %system %iowait %steal %idle

02:53:17 PM all 066 000 172 066 000 9696

02:53:19 PM all 134 000 335 080 000 9451

02:53:21 PM all 079 000 159 145 000 9617

02:53:23 PM all 040 000 200 080 000 9680

02:53:25 PM all 066 000 185 079 000 9670

Average: all 077 000 210 090 000 9623

2 top

top -a 按照内存降序

[root@dbhost01 ~]# top -a

top - 15:00:54 up 6:04, 1 user, load average: 031, 019, 011

Tasks: 306 total, 1 running, 305 sleeping, 0 stopped, 0 zombie

Cpu(s): 78%us, 24%sy, 00%ni, 889%id, 08%wa, 00%hi, 01%si, 00%st

Mem: 4048972k total, 3848576k used, 200396k free, 134844k buffers

Swap: 4194300k total, 1788k used, 4192512k free, 1835360k cached

3 vmstat

vmstat用于显示虚拟内存，内核线程，磁盘，系统进程， CPU活动等统计信息。

需要安装sysstat工具。

[root@dbhost01 ~]# vmstat

procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----

r b swpd free buff cache si so bi bo in cs us sy id wa st

2 0 1788 202508 135064 1835920 0 0 32 26 96 276 1 2 95 1 0

[root@dbhost01 ~]#

[root@dbhost01 ~]# vmstat 2 5

procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----

r b swpd free buff cache si so bi bo in cs us sy id wa st

0 0 1788 202336 135068 1836000 0 0 32 26 97 276 1 2 95 1 0

0 0 1788 202624 135068 1836000 0 0 25 29 4012 6682 0 1 98 1 0

0 0 1788 202624 135072 1836004 0 0 57 87 4003 6685 0 1 98 1 0

1 0 1788 202508 135072 1836004 0 0 57 33 4402 7353 1 1 98 0 0

0 0 1788 202540 135076 1836004 0 0 33 47 4002 6674 0 1 98 1 0

4 lsof(list open files)

[root@dbhost01 ~]# lsof | grep 1521

certmonge 2348 root 16r FIFO 0,8 0t0 15212 pipe

certmonge 2348 root 18r FIFO 0,8 0t0 15218 pipe

gipcdbin 2754 grid 109u unix 0xffff880139152180 0t0 36936 socket

5 tcpdump

tcpdump -i eth1

15:24:28777779 IP dbhost01ssh > 19216828250990: Flags [P], seq 393080:393596, ack 105, win 148, options [nop,nop,TS val 22996360 ecr 2443327], length 516

15:24:28777809 IP dbhost01ssh > 19216828250990: Flags [P], seq 393080:393596, ack 105, win 148, options [nop,nop,TS val 22996360 ecr 2443327], length 516

15:24:28778976 IP dbhost01ssh > 19216828250990: Flags [P], seq 393596:393968, ack 105, win 148, options [nop,nop,TS val 22996361 ecr 2443327], length 372

15:24:28779011 IP dbhost01ssh > 19216828250990: Flags [P], seq 393596:393968, ack 105, win 148, options [nop,nop,TS val 22996361 ecr 2443327], length 372

15:24:28779013 IP 19216828250990 > dbhost01ssh: Flags [], ack 393968, win 16652, options [nop,nop,TS val 2443327 ecr 22996360], length 0

15:24:28779481 IP dbhost02-priv23602 > dbhost01-priv24271: UDP, length 556

15:24:28779585 IP dbhost01-priv24271 > dbhost02-priv23602: UDP, length 80

15:24:28779909 IP dbhost01-priv24271 > dbhost02-priv23602: UDP, length 80

15:24:28780584 IP dbhost01ssh > 19216828250990: Flags [P], seq 393968:394724, ack 105, win 148, options [nop,nop,TS val 22996362 ecr 2443327], length 756

15:24:28780590 IP dbhost01ssh > 19216828250990: Flags [P], seq 393968:394724, ack 105, win 148, options [nop,nop,TS val 22996362 ecr 2443327], length 756

15:24:28780820 IP dbhost01-priv24271 > dbhost02-priv23602: UDP, length 556

15:24:28782232 IP dbhost01ssh > 19216828250990: Flags [P], seq 394724:395176, ack 105, win 148, options [nop,nop,TS val 22996364 ecr 2443327], length 452

15:24:28782235 IP dbhost01ssh > 19216828250990: Flags [P], seq 394724:395176, ack 105, win 148, options [nop,nop,TS val 22996364 ecr 2443327], length 452

6netstat

[root@dbhost01 ~]# netstat -a | grep oracle

unix 2 [ ACC ] STREAM LISTENING 31861 /var/tmp/oracle/ora_gipc_sdbhost01gridmyracdb-clusterCRFM_SIPC

unix 2 [ ACC ] STREAM LISTENING 33820 /var/tmp/oracle/sdbhost01DBG_LOGD

unix 2 [ ACC ] STREAM LISTENING 41177 /var/tmp/oracle/sdbhost01DBG_EVMD

unix 2 [ ACC ] STREAM LISTENING 65106 /var/tmp/oracle/sAevm

unix 2 [ ACC ] STREAM LISTENING 65108 /var/tmp/oracle/sSYSTEMevmacceptorauth

7 htop

需要安装

8 iostat

Total DISK READ: 9148 K/s | Total DISK WRITE: 4527 K/s

TID PRIO USER DISK READ DISK WRITE SWAPIN IO> COMMAND

4071 be/4 oracle 3018 K/s 000 B/s 000 % 469 % ora_lmon_orcl1

4117 be/4 oracle 6036 K/s 1509 K/s 000 % 369 % ora_ckpt_orcl1

2989 rt/4 grid 96571 B/s 000 B/s 000 % 213 % ocssdbin

4099 be/4 oracle 000 B/s 3018 K/s 000 % 007 % ora_ckpt_test

2987 rt/4 grid 000 B/s 48286 B/s 000 % 003 % ocssdbin

2979 rt/3 root 000 B/s 377 K/s 000 % 000 % ologgerd -M -d /g01/grid/app/1120/grid/crf/db/dbhost01

2980 rt/3 root 000 B/s 1509 K/s 000 % 000 % ologgerd -M -d /g01/grid/app/1120/grid/crf/db/dbhost01

9 iftop(流量监控工具)

以上就是关于有没有什么工具可以监控oracle数据库里数据的变化全部的内容，包括:有没有什么工具可以监控oracle数据库里数据的变化、几个常用的linux性能监控命令、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！