Oracle sqlplus连接很慢
发布时间：2020-12-12 16:03:00 所属栏目：百科 来源：网络整理
导读：一个测试库上有很多个用户，其中的一个用户修改密码之后，就出现了连接缓慢的情况，而这个数据库上其他的用户连接没有问题。这种问题得先用strace跟踪一下： strace -T -t -o /tmp/s.out sqlplus test/test -T Show the time spent in system calls. This re
|
一个测试库上有很多个用户，其中的一个用户修改密码之后，就出现了连接缓慢的情况，而这个数据库上其他的用户连接没有问题。这种问题得先用strace跟踪一下： strace -T -t -o /tmp/s.out sqlplus test/test -T Show the time spent in system calls. This records the time difference between the beginning and the end of each system call.-o Write the trace output to the file filename rather than to stderr. -t Prefix each line of the trace with the time of day. 13:55:09 execve("/data1/oracle11g/product/11.2.0.4/db_1/bin/sqlplus",["sqlplus","lcam_zc_0130/lcam_zc_pzgpassword"...],[/* 32 vars */]) = 0 <0.000364> 13:55:09 brk(0) = 0x1ea1000 <0.000040> 13:55:09 mmap(NULL,4096,PROT_READ|PROT_WRITE,MAP_PRIVATE|MAP_ANONYMOUS,-1,0) = 0x7f32071aa000 <0.000025> 13:55:09 access("/etc/ld.so.preload",R_OK) = -1 ENOENT (No such file or directory) <0.000044> 13:55:09 open("/data1/oracle11g/product/11.2.0.4/db_1/lib/tls/x86_64/libsqlplus.so",O_RDONLY) = -1 ENOENT (No such file or directory) <0.000025> 13:55:09 stat("/data1/oracle11g/product/11.2.0.4/db_1/lib/tls/x86_64",0x7fff3e3dacf0) = -1 ENOENT (No such file or directory) <0.000013> 13:55:09 open("/data1/oracle11g/product/11.2.0.4/db_1/lib/tls/libsqlplus.so",O_RDONLY) = -1 ENOENT (No such file or directory) <0.000014> 13:55:09 stat("/data1/oracle11g/product/11.2.0.4/db_1/lib/tls",0x7fff3e3dacf0) = -1 ENOENT (No such file or directory) <0.000012> 13:55:09 open("/data1/oracle11g/product/11.2.0.4/db_1/lib/x86_64/libsqlplus.so",O_RDONLY) = -1 ENOENT (No such file or directory) <0.000014> 13:55:09 stat("/data1/oracle11g/product/11.2.0.4/db_1/lib/x86_64",0x7fff3e3dacf0) = -1 ENOENT (No such file or directory) <0.000013> 13:55:09 open("/data1/oracle11g/product/11.2.0.4/db_1/lib/libsqlplus.so",O_RDONLY) = 3 <0.000019> ......................... 13:55:10 write(10,"5z 6 3s3376377377377377377377377f 11 376377377"...,1402) = 1402 <0.000016> 13:55:10 read(11,"4222 6 1031 23 23AUTH_VERSION_S"...,8208) = 1170 <5.886348> 13:55:15 open("/data1/oracle11g/product/11.2.0.4/db_1/rdbms/mesg/oraus.msb",O_RDONLY) = 9 <0.000075> 13:55:15 fcntl(9,F_SETFD,FD_CLOEXEC) = 0 <0.000013>
很可惜，不知道这个是什么意思，因为有很多weblogic连到这个库上，weblogic有自动重连的机制，然后把weblogic连接池的密码都修改完后，sqlplus连接速度正常了。真是乱拳打死老师傅啊，问题解决了。 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |