oracle sqlplus登录慢,sqlplus登录过慢，求助

最新推荐文章于 2023-12-22 23:01:48 发布
最新推荐文章于 2023-12-22 23:01:48 发布
阅读量546 收藏
点赞数
文章标签： oracle sqlplus登录慢

rhel4.7 64bit

oracle 10.2.0.4 64bit

数据库登录比较慢，大概要2秒左右，服务器上跟踪sqlplus程序，有以下输出：

geteuid()                               = 600 <0.000078>

setreuid(600, 600)                      = 0 <0.000024>

kill(23231, SIGSTOP)                    = 0 <0.000020>

--- SIGSTOP (Stopped (signal)) @ 0 (0) ---

--- SIGSTOP (Stopped (signal)) @ 0 (0) ---

execve("/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus", ["sqlplus", "/nolog"], [/* 29 vars */]) = 0 <0.000178>

uname({sys="Linux", node="dbrhel4", ...}) = 0 <0.000018>

brk(0)                                  = 0x501000 <0.000018>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a95556000 <0.000040>

access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory) <0.000062>

open("/u01/app/oracle/product/10.2.0/db_1/lib/tls/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000043>

stat("/u01/app/oracle/product/10.2.0/db_1/lib/tls/x86_64", 0x7fbfffecd0) = -1 ENOENT (No such file or directory) <0.000024>

open("/u01/app/oracle/product/10.2.0/db_1/lib/tls/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000046>

stat("/u01/app/oracle/product/10.2.0/db_1/lib/tls", 0x7fbfffecd0) = -1 ENOENT (No such file or directory) <0.000040>

open("/u01/app/oracle/product/10.2.0/db_1/lib/x86_64/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000040>

stat("/u01/app/oracle/product/10.2.0/db_1/lib/x86_64", 0x7fbfffecd0) = -1 ENOENT (No such file or directory) <0.000038>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so", O_RDONLY) = 3 <0.000041>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\252\2\0\0\0\0\0"..., 832) = 832 <0.000045>

fstat(3, {st_mode=S_IFREG|0644, st_size=997409, ...}) = 0 <0.000018>

mmap(NULL, 2043464, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2a95557000 <0.000023>

mprotect(0x2a9563d000, 1101384, PROT_NONE) = 0 <0.000023>

mmap(0x2a9573d000, 53248, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe6000) = 0x2a9573d000 <0.000025>

close(3)                                = 0 <0.000019>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1", O_RDONLY) = 3 <0.000045>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\16&\0\0\0\0\0"..., 832) = 832 <0.000065>

fstat(3, {st_mode=S_IFREG|0750, st_size=21003464, ...}) = 0 <0.000019>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a9574a000 <0.000022>

mmap(NULL, 20716392, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2a9574b000 <0.000021>

mprotect(0x2a9694e000, 1829736, PROT_NONE) = 0 <0.000021>

mmap(0x2a96a4d000, 671744, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1202000) = 0x2a96a4d000 <0.000088>

mmap(0x2a96af1000, 113512, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x2a96af1000 <0.000043>

close(3)                                = 0 <0.000018>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so", O_RDONLY) = 3 <0.000052>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200\275\f\0\0\0\0\0"..., 832) = 832 <0.000029>

fstat(3, {st_mode=S_IFREG|0644, st_size=3796601, ...}) = 0 <0.000019>

mmap(NULL, 4848040, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2a96b0d000 <0.000023>

mprotect(0x2a96dfc000, 1771944, PROT_NONE) = 0 <0.000024>

mmap(0x2a96efb000, 724992, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2ee000) = 0x2a96efb000 <0.000044>

mmap(0x2a96fac000, 2472, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x2a96fac000 <0.000041>

close(3)                                = 0 <0.000035>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000045>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000025>

open("/etc/ld.so.cache", O_RDONLY)      = 3 <0.000024>

fstat(3, {st_mode=S_IFREG|0644, st_size=127759, ...}) = 0 <0.000018>

mmap(NULL, 127759, PROT_READ, MAP_PRIVATE, 3, 0) = 0x2a96fad000 <0.000022>

close(3)                                = 0 <0.000017>

open("/lib64/libdl.so.2", O_RDONLY)     = 3 <0.000047>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\200\17`\206

fstat(3, {st_mode=S_IFREG|0755, st_size=19800, ...}) = 0 <0.000019>

mmap(0x3c86600000, 1056968, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c86600000 <0.000071>

mprotect(0x3c86602000, 1048776, PROT_NONE) = 0 <0.000035>

mmap(0x3c86701000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x3c86701000 <0.000026>

close(3)                                = 0 <0.000018>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000032>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000045>

open("/lib64/tls/libm.so.6", O_RDONLY)  = 3 <0.000048>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360=\200\206

fstat(3, {st_mode=S_IFREG|0755, st_size=643240, ...}) = 0 <0.000018>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a96fcd000 <0.000022>

mmap(0x3c86800000, 1593800, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c86800000 <0.000022>

mprotect(0x3c86885000, 1049032, PROT_NONE) = 0 <0.000058>

mmap(0x3c86984000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x84000) = 0x3c86984000 <0.000041>

close(3)                                = 0 <0.000019>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000045>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000040>

open("/lib64/tls/libpthread.so.0", O_RDONLY) = 3 <0.000031>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0 V\340\206

fstat(3, {st_mode=S_IFREG|0755, st_size=129952, ...}) = 0 <0.000022>

mmap(0x3c86e00000, 1131384, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c86e00000 <0.000023>

mprotect(0x3c86e10000, 1065848, PROT_NONE) = 0 <0.000025>

mmap(0x3c86f0f000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xf000) = 0x3c86f0f000 <0.000026>

mmap(0x3c86f11000, 13176, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c86f11000 <0.000041>

close(3)                                = 0 <0.000017>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000027>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000052>

open("/lib64/libnsl.so.1", O_RDONLY)    = 3 <0.000047>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`M0\216

fstat(3, {st_mode=S_IFREG|0755, st_size=114976, ...}) = 0 <0.000019>

mmap(0x3c8e300000, 1145936, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c8e300000 <0.000024>

mprotect(0x3c8e315000, 1059920, PROT_NONE) = 0 <0.000038>

mmap(0x3c8e414000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14000) = 0x3c8e414000 <0.000025>

mmap(0x3c8e416000, 7248, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c8e416000 <0.000056>

close(3)                                = 0 <0.000019>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000044>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000041>

open("/lib64/tls/libc.so.6", O_RDONLY)  = 3 <0.000042>

read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\3041\206

fstat(3, {st_mode=S_IFREG|0755, st_size=1635416, ...}) = 0 <0.000018>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a96fce000 <0.000022>

mmap(0x3c86300000, 2326568, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c86300000 <0.000027>

mprotect(0x3c8642f000, 1085480, PROT_NONE) = 0 <0.000022>

mmap(0x3c8652f000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x12f000) = 0x3c8652f000 <0.000043>

mmap(0x3c86534000, 16424, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c86534000 <0.000042>

close(3)                                = 0 <0.000018>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a96fcf000 <0.000059>

mprotect(0x3c8652f000, 12288, PROT_READ) = 0 <0.000041>

mprotect(0x3c8e414000, 4096, PROT_READ) = 0 <0.000027>

mprotect(0x3c86f0f000, 4096, PROT_READ) = 0 <0.000024>

mprotect(0x3c86984000, 4096, PROT_READ) = 0 <0.000024>

mprotect(0x3c86701000, 4096, PROT_READ) = 0 <0.000027>

mprotect(0x2a96b0d000, 3076096, PROT_READ|PROT_WRITE) = 0 <0.000039>

mprotect(0x2a96b0d000, 3076096, PROT_READ|PROT_EXEC) = 0 <0.000041>

mprotect(0x2a9574b000, 18886656, PROT_READ|PROT_WRITE) = 0 <0.000029>

mprotect(0x2a9574b000, 18886656, PROT_READ|PROT_EXEC) = 0 <0.000079>

mprotect(0x2a95557000, 942080, PROT_READ|PROT_WRITE) = 0 <0.000023>

mprotect(0x2a95557000, 942080, PROT_READ|PROT_EXEC) = 0 <0.000025>

mprotect(0x3c86214000, 4096, PROT_READ) = 0 <0.000026>

arch_prctl(ARCH_SET_FS, 0x2a96fcf700)   = 0 <0.000019>

munmap(0x2a96fad000, 127759)            = 0 <0.000031>

set_tid_address(0x2a96fcf790)           = 23231 <0.000018>

rt_sigaction(SIGRTMIN, {0x3c86e05190, [], SA_RESTORER|SA_SIGINFO, 0x3c86e0c5b0}, NULL, 8) = 0 <0.000021>

rt_sigaction(SIGRT_1, {0x3c86e05210, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c86e0c5b0}, NULL, 8) = 0 <0.000034>

rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0 <0.000019>

getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0 <0.000019>

_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0x7fbffff510, 34, (nil), 0}) = 0 <0.000040>

brk(0)                                  = 0x501000 <0.000019>

brk(0x522000)                           = 0x522000 <0.000020>

mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a96fd0000 <0.000023>

futex(0x3c867020c4, FUTEX_WAKE, 2147483647) = 0 <0.000022>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000068>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000030>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000030>

open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx1boot.nlb", O_RDONLY) = 3 <0.000031>

read(3, "\0\0\0\3\0\4 \n\20W\0\0@\323\215\0\0\0\0\0\1\0C\0\273\0\300\1\26\2(\2"..., 48) = 48 <0.000028>

read(3, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 22240) = 22240 <0.000107>

close(3)                                = 0 <0.000021>

open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx00001.nlb", O_RDONLY) = 3 <0.000048>

read(3, "\0\0\0\3\0\4 \n\267\3\0\0s\2\0\0\0\0\0\0\0\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92 <0.000043>

read(3, "\3\0\0\0\1\0\1\0\1\0`\0\0\0\4\0\6\0\10\0\n\0\20\0\30\0 \0(\0000\0"..., 860) = 859 <0.000020>

close(3)                                = 0 <0.000019>

brk(0x559000)                           = 0x559000 <0.000022>

open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx20354.nlb", O_RDONLY) = 3 <0.000048>

read(3, "\0\0\0\3\0\4 \n\311\276\1\0\35\265\1\0\0\0\0\0\2\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92 <0.000027>

read(3, "T\3\0\0\21\0\1\0\277\0\0\0\0\0\0\0 ~?\201@\0\0\2\376\0\0\0\0\0\0\0"..., 114292) = 114292 <0.000275>

close(3)                                = 0 <0.000020>

open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx10001.nlb", O_RDONLY) = 3 <0.000047>

read(3, "\0\0\0\3\0\4 \nt\4\0\0\220\3\0\0\0\0\0\0\1\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92 <0.000026>

read(3, "\3\0\0\0\1\0\1\0\0\0\0\0\0\0\4\0\1\0\2\0\2\0\1\0\1\0\0\0\0\0\0\0"..., 1052) = 1048 <0.000019>

close(3)                                = 0 <0.000019>

open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx20001.nlb", O_RDONLY) = 3 <0.000034>

read(3, "\0\0\0\3\0\4 \n9\33\0\0\215\21\0\0\0\0\0\0\2\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92 <0.000023>

read(3, "\1\0\37\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\1\0\0\0\0\0\0\0\0"..., 6884) = 6877 <0.000032>

close(3)                                = 0 <0.000037>

open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx40001.nlb", O_RDONLY) = 3 <0.000060>

read(3, "\0\0\0\3\0\4 \n\370}\0\0\324|\0\0\0\0\0\0\4\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92 <0.000027>

read(3, "\0\0\0\0\4\0\0\0\4\0\0\0\274O\0\0\34[\0\0\344\\\0\0\364]\0\0\344`\0\0"..., 32156) = 32156 <0.000228>

close(3)                                = 0 <0.000018>

open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/mesg/sp1us.msb", O_RDONLY) = 3 <0.000080>

fcntl(3, F_SETFD, FD_CLOEXEC)           = 0 <0.000019>

lseek(3, 0, SEEK_SET)                   = 0 <0.000018>

read(3, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256 <0.000055>

open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/mesg/sp2us.msb", O_RDONLY) = 4 <0.000056>

fcntl(4, F_SETFD, FD_CLOEXEC)           = 0 <0.000019>

lseek(4, 0, SEEK_SET)                   = 0 <0.000020>

read(4, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256 <0.000023>

open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/mesg/cpyus.msb", O_RDONLY) = 5 <0.000048>

fcntl(5, F_SETFD, FD_CLOEXEC)           = 0 <0.000033>

lseek(5, 0, SEEK_SET)                   = 0 <0.000019>

read(5, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256 <0.000024>

lseek(5, 512, SEEK_SET)                 = 512 <0.000019>

read(5, "\f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512 <0.000019>

lseek(5, 1024, SEEK_SET)                = 1024 <0.000019>

read(5, "\t\0\f\0", 4)                  = 4 <0.000019>

open("/etc/localtime", O_RDONLY)        = 6 <0.000030>

fstat(6, {st_mode=S_IFREG|0644, st_size=165, ...}) = 0 <0.000027>

fstat(6, {st_mode=S_IFREG|0644, st_size=165, ...}) = 0 <0.000020>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a96ff3000 <0.000022>

read(6, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\3\0\0\0\3\0\0\0\0"..., 4096) = 165 <0.000038>

close(6)                                = 0 <0.000021>

munmap(0x2a96ff3000, 4096)              = 0 <0.000026>

open("/u01/app/oracle/product/10.2.0/db_1/oracore/zoneinfo/timezlrg.dat", O_RDONLY) = 6 <0.000057>

fstat(6, {st_mode=S_IFREG|0644, st_size=408315, ...}) = 0 <0.000020>

mmap(NULL, 408315, PROT_READ, MAP_PRIVATE|MAP_NORESERVE, 6, 0) = 0x2a96ff3000 <0.000065>

close(6)                                = 0 <0.000018>

open("/u01/app/oracle/product/10.2.0/db_1/rdbms/mesg/ocius.msb", O_RDONLY) = 6 <0.000073>

fcntl(6, F_SETFD, FD_CLOEXEC)           = 0 <0.000018>

lseek(6, 0, SEEK_SET)                   = 0 <0.000018>

read(6, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256 <0.000030>

lseek(6, 512, SEEK_SET)                 = 512 <0.000019>

read(6, "\337y\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512 <0.000020>

lseek(6, 1024, SEEK_SET)                = 1024 <0.000017>

read(6, "\25\7\'\0072\7>\7j\7\276\17$\'\6K5S\24TfT\307T(VsV\222V\6W"..., 86) = 86 <0.000020>

brk(0x57d000)                           = 0x57d000 <0.000023>

times(NULL)                             = 480682801 <0.000019>

rt_sigprocmask(SIG_BLOCK, [INT], NULL, 8) = 0 <0.000036>

rt_sigaction(SIGINT, {0x2a965094e0, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c86e0c5b0}, {SIG_IGN}, 8) = 0 <0.000036>

rt_sigprocmask(SIG_UNBLOCK, [INT], NULL, 8) = 0 <0.000033>

brk(0x5a4000)                           = 0x5a4000 <0.000022>

fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0 <0.000022>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97057000 <0.000023>

write(1, "\n", 1)                       = 1 <0.000020>

write(1, "SQL*Plus: Release 10.2.0.4.0 - P"..., 70) = 70 <0.000023>

write(1, "\n", 1)                       = 1 <0.000019>

write(1, "Copyright (c) 1982, 2007, Oracle"..., 56) = 56 <0.000021>

write(1, "\n", 1)                       = 1 <0.000019>

mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97058000 <0.000023>

munmap(0x2a97058000, 143360)            = 0 <0.000049>

access("login.sql", F_OK)               = -1 ENOENT (No such file or directory) <0.000028>

mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97058000 <0.000026>

munmap(0x2a97058000, 143360)            = 0 <0.000049>

access("/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/login.sql", F_OK) = -1 ENOENT (No such file or directory) <0.000031>

mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97058000 <0.000023>

munmap(0x2a97058000, 143360)            = 0 <0.000033>

access("/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql", F_OK) = 0 <0.000067>

statfs("/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql", {f_type="EXT2_SUPER_MAGIC", f_bsize=4096, f_blocks=38704122, f_bfree=28479670, f_bavail=26513616, f_files=19660800, f_ffree=19639579, f_fsid={0, 0}, f_namelen=255, f_frsize=4096}) = 0 <0.000388>

open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql", O_RDONLY) = 7 <0.000027>

read(7, "--\n-- Copyright (c) 1988, 2004, "..., 57344) = 1525 <0.000038>

brk(0x5cf000)                           = 0x5cf000 <0.000020>

read(7, "", 57344)                      = 0 <0.000020>

brk(0x5c1000)                           = 0x5c1000 <0.000023>

brk(0x5b3000)                           = 0x5b3000 <0.000020>

close(7)                                = 0 <0.000021>

write(1, "SQL> ", 5)                    = 5 <0.000018>

fstat(0, {st_mode=S_IFREG|0600, st_size=22, ...}) = 0 <0.000019>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97058000 <0.000020>

read(0, "conn test/test;\nexit;\n", 4096) = 22 <0.000025>

getcwd("/home/oracle", 256)             = 13 <0.000023>

access("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora", F_OK) = 0 <0.000059>

open("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora", O_RDONLY) = 7 <0.000026>

fcntl(7, F_SETFD, FD_CLOEXEC)           = 0 <0.000017>

brk(0x5d4000)                           = 0x5d4000 <0.000019>

fstat(7, {st_mode=S_IFREG|0644, st_size=86, ...}) = 0 <0.000026>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97059000 <0.000020>

read(7, "SQLNET.INBOUND_CONNECT_TIMEOUT ="..., 4096) = 86 <0.000037>

read(7, "", 4096)                       = 0 <0.000018>

close(7)                                = 0 <0.000019>

munmap(0x2a97059000, 4096)              = 0 <0.000025>

access("/home/oracle/.sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory) <0.000025>

access("/home/oracle/cli_23231.trc", F_OK) = -1 ENOENT (No such file or directory) <0.000053>

access("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora", F_OK) = 0 <0.000027>

open("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora", O_RDONLY) = 7 <0.000025>

fcntl(7, F_SETFD, FD_CLOEXEC)           = 0 <0.000017>

fstat(7, {st_mode=S_IFREG|0644, st_size=86, ...}) = 0 <0.000018>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97059000 <0.000021>

read(7, "SQLNET.INBOUND_CONNECT_TIMEOUT ="..., 4096) = 86 <0.000025>

read(7, "", 4096)                       = 0 <0.000018>

close(7)                                = 0 <0.000018>

munmap(0x2a97059000, 4096)              = 0 <0.000024>

access("/etc/intchg.ora", F_OK)         = -1 ENOENT (No such file or directory) <0.000023>

access("/u01/app/oracle/product/10.2.0/db_1/network/admin/intchg.ora", F_OK) = -1 ENOENT (No such file or directory) <0.000024>

access("/etc/tnsnav.ora", F_OK)         = -1 ENOENT (No such file or directory) <0.000024>

access("/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnav.ora", F_OK) = -1 ENOENT (No such file or directory) <0.000025>

open("/proc/self/cmdline", O_RDONLY)    = 7 <0.000064>

read(7, "sqlplus\0\0\0\0\0\0\0\0", 255) = 15 <0.000024>

close(7)                                = 0 <0.000018>

uname({sys="Linux", node="dbrhel4", ...}) = 0 <0.000018>

getuid()                                = 600 <0.000019>

socket(PF_FILE, SOCK_STREAM, 0)         = 7 <0.000034>

fcntl(7, F_GETFL)                       = 0x2 (flags O_RDWR) <0.000018>

fcntl(7, F_SETFL, O_RDWR|O_NONBLOCK)    = 0 <0.000019>

connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory) <0.000098>

close(7)                                = 0 <0.000024>

socket(PF_FILE, SOCK_STREAM, 0)         = 7 <0.000041>

fcntl(7, F_GETFL)                       = 0x2 (flags O_RDWR) <0.000018>

fcntl(7, F_SETFL, O_RDWR|O_NONBLOCK)    = 0 <0.000036>

connect(7, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory) <0.000067>

close(7)                                = 0 <0.000023>

open("/etc/nsswitch.conf", O_RDONLY)    = 7 <0.000026>

fstat(7, {st_mode=S_IFREG|0644, st_size=1623, ...}) = 0 <0.000020>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97059000 <0.000022>

read(7, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1623 <0.000048>

read(7, "", 4096)                       = 0 <0.000020>

close(7)                                = 0 <0.000019>

munmap(0x2a97059000, 4096)              = 0 <0.000042>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000045>

open("/u01/app/oracle/product/10.2.0/db_1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory) <0.000060>

open("/etc/ld.so.cache", O_RDONLY)      = 7 <0.000040>

fstat(7, {st_mode=S_IFREG|0644, st_size=127759, ...}) = 0 <0.000018>

mmap(NULL, 127759, PROT_READ, MAP_PRIVATE, 7, 0) = 0x2a97059000 <0.000022>

close(7)                                = 0 <0.000027>

open("/lib64/libnss_files.so.2", O_RDONLY) = 7 <0.000051>

read(7, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\"\0\0\0\0\0\0"..., 832) = 832 <0.000024>

fstat(7, {st_mode=S_IFREG|0755, st_size=58872, ...}) = 0 <0.000019>

mmap(NULL, 1094952, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 7, 0) = 0x2a97079000 <0.000024>

mprotect(0x2a97083000, 1053992, PROT_NONE) = 0 <0.000040>

mmap(0x2a97183000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 7, 0xa000) = 0x2a97183000 <0.000042>

close(7)                                = 0 <0.000019>

mprotect(0x2a97183000, 4096, PROT_READ) = 0 <0.000025>

munmap(0x2a97059000, 127759)            = 0 <0.000028>

open("/etc/passwd", O_RDONLY)           = 7 <0.000043>

fcntl(7, F_GETFD)                       = 0 <0.000018>

fcntl(7, F_SETFD, FD_CLOEXEC)           = 0 <0.000017>

fstat(7, {st_mode=S_IFREG|0644, st_size=1646, ...}) = 0 <0.000018>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97059000 <0.000021>

read(7, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1646 <0.000033>

close(7)                                = 0 <0.000019>

munmap(0x2a97059000, 4096)              = 0 <0.000024>

getrlimit(RLIMIT_NOFILE, {rlim_cur=64*1024, rlim_max=64*1024}) = 0 <0.000018>

socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 7 <0.000028>

bind(7, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("127.0.0.1")}, 16) = 0 <0.000025>

getsockname(7, {sa_family=AF_INET, sin_port=htons(1117), sin_addr=inet_addr("127.0.0.1")}, [180388626448]) = 0 <0.000018>

getpeername(7, 0x7fbfff59bc, [180388626448]) = -1 ENOTCONN (Transport endpoint is not connected) <0.000018>

getsockopt(7, SOL_SOCKET, SO_SNDBUF, [-8786334401244692480], [4]) = 0 <0.000018>

getsockopt(7, SOL_SOCKET, SO_RCVBUF, [-8786334401243906048], [4]) = 0 <0.000017>

fcntl(7, F_SETFD, FD_CLOEXEC)           = 0 <0.000017>

fcntl(7, F_SETFL, O_RDONLY|O_NONBLOCK)  = 0 <0.000018>

rt_sigaction(SIGCHLD, NULL, {SIG_DFL}, 8) = 0 <0.000018>

rt_sigprocmask(SIG_BLOCK, [CHLD], NULL, 8) = 0 <0.000017>

rt_sigaction(SIGCHLD, {0x2a965094e0, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c86e0c5b0}, {SIG_DFL}, 8) = 0 <0.000018>

rt_sigprocmask(SIG_UNBLOCK, [CHLD], NULL, 8) = 0 <0.000017>

pipe([8, 9])                            = 0 <0.000025>

pipe([10, 11])                          = 0 <0.000021>

clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x2a96fcf790) = 23232 <0.000408>

rt_sigprocmask(SIG_BLOCK, [PIPE], NULL, 8) = 0 <0.000018>

rt_sigaction(SIGPIPE, {0x2a965094e0, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c86e0c5b0}, {SIG_IGN}, 8) = 0 <0.000020>

rt_sigprocmask(SIG_UNBLOCK, [PIPE], NULL, 8) = 0 <0.000019>

close(8)                                = 0 <0.000018>

close(11)                               = 0 <0.000017>

read(10, "NTP0 23232\n", 64)            = 11 <1.592426>

fcntl(10, F_SETFD, FD_CLOEXEC)          = 0 <0.000013>

write(9, "\0:\0\0\1\0\0\0\0019\1,\f\1\10\0\20\0O\230\0\0\1\0\1\0\0:\0\0\2\0"..., 58) = 58 <0.000051>

write(9, "\1\n\0\0\6\0\0\0\0\0(DESCRIPTION=(ADDRESS="..., 266) = 266 <0.000032>

read(10, "\0 \0\0\2\0\0\0\0019\f\1\10\0\20\0\1\0\0\0\0 AA\0\0\0\0\0\0\0\0", 2064) = 32 <0.000011>

write(9, "\0\250\0\0\6\0\0\0\0\0\336\255\276\357\0\236\n \4\0\0\4\0\0\4\0\3\0\0\0\0\0"..., 168) = 168 <0.000029>

read(10, "\0\213\0\0\6\0\0\0\0\0\336\255\276\357\0\201\n \4\0\0\4\0\0\4\0\3\0\0\0\0\0"..., 2064) = 139 <0.000012>

getuid()                                = 600 <0.000011>

getppid()                               = 23230 <0.000010>

rt_sigaction(SIGTSTP, {SIG_IGN}, {SIG_DFL}, 8) = 0 <0.000013>

readlink("/proc/self/fd/0", "/tmp/sh-thd-1309237961 (deleted)", 254) = 32 <0.000053>

ioctl(0, SNDCTL_TMR_TIMEBASE or TCGETS, 0x7fbfff7b50) = -1 ENOTTY (Inappropriate ioctl for device) <0.000023>

getuid()                                = 600 <0.000010>

open("/etc/passwd", O_RDONLY)           = 8 <0.000026>

fcntl(8, F_GETFD)                       = 0 <0.000010>

fcntl(8, F_SETFD, FD_CLOEXEC)           = 0 <0.000010>

fstat(8, {st_mode=S_IFREG|0644, st_size=1646, ...}) = 0 <0.000022>

mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a97059000 <0.000014>

read(8, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1646 <0.000018>

TheCyberSecHub
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
sqlplus登录缓慢的问题分析过程及解决小记
Enmotech的博客
05-10 809
点击上方"蓝字"关注我们，享更多干货！一、问题描述近日在某客户现场进行巡检，发现有一个系统在进行sqlplus / as sysdba登录的时候特别缓慢。多次测试，最长时间...
sqlplus登录Oracle的四种方法
05-12
本文将详细讲解通过Sqlplus、PL/SQL Developer、iSqlPlus三种工具以及命令行方式登录Oracle数据库的四种方法。 首先，Sqlplus是Oracle提供的一种命令行接口，用于连接到Oracle数据库进行查询、管理等操作。以下是...
oracle sqlplus登录缓慢
direction
08-01 2115
1.网络慢。网络状况可以通过ping进行测试，ping大包、长ping均可。 2.tnsnames.ora或者监听中使用了主机名。主机名是需要通过本地hosts或者dns来进行解析的，如果解析缓慢会导致连接缓慢，可以使用ip来代替主机名从而跳过这个问题。此问题的排查方法可以通过创建一个使用ip的tnsnames来进行测试，比较使用ip的和使用hostname个需要多长时间。 3.监听日志文件过
oracle sqlplus登录慢,Oracle sqlplus连接很慢
weixin_39619893的博客
04-03 192
一个测试库上有很多个用户，其中的一个用户修改密码之后，就出现了连接缓慢的情况，而这个数据库上其他的用户连接没有问题。这种问题得先用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...
oracle数据库sqlplus登录卡顿
最新发布
bing_yuan的博客
12-22 1066
新安装了一套oracle 11.2.0.1 版本的数据库服务器，出现了在服务器本地通过sqlplus / as sysdba登录的时候很快，但是通过监听登录的时候就非常的慢，卡顿，大概需要1分钟多的时间才能登进数据库。之前安装了好几套oracle 19.3.0版本的数据库也没有出现这种情况，不知道问题出现在哪里？
oracle sqlplus登录慢,【Oracle】/etc/resolv.conf配置导致的sqlplus登录过慢
weixin_32307599的博客
04-03 820
症状描述：在linux下使用登录非常慢，大概需要十几秒才能登录成功，使用sqlplus/assysdba登录数据库速度很快，秒登。使用登录会卡在下面这个位置十几秒：SQL*Plus:Release10.2.0.1.0-ProductiononWedMar2623:32:292014Copyright(c)1982,2005,Oracle.Allrights...
strace分析SQLPLUS登陆慢问题
ciqingloveless的博客
08-03 656
strace -f -ttt -o sqlplus.trc sqlplus / as sysdba
Oracle SQLPLUS基础及sqlplus命令详解
10-03
Oracle SQLPLUS基础及sqlplus命令详解，详细阐述了oracle sqlplus基本命令和相关用法
Oracle SqlPlus设置Login.sql的技巧
09-10
Oracle SQLPlus是一款强大的数据库管理工具，它允许用户与Oracle数据库进行交互式操作或运行SQL脚本。在使用SQLPlus时，有一些配置技巧可以提升工作效率，尤其是通过设置Login.sql文件。Login.sql是SQLPlus启动时...
Oracle SQLPlus导出数据到csv文件的方法
09-08
Oracle SQLPlus是一款强大的数据库管理工具，它允许用户与Oracle数据库进行交互，执行SQL查询和脚本，以及进行数据导出等操作。在某些场景下，将数据导出为CSV（逗号分隔值）文件是一种常见需求，例如备份、数据分析...
sqlplus登录\连接命令、sqlplus命令的使用大全
09-10
Oracle的sql*plus是与oracle进行交互的客户端工具。在sqlplus中，可以运行sqlplus命令与sqlplus语句
sqlplus登录问题慢分析过程及解决小记
wx370092877的博客
05-10 542
一、问题描述 今天，在某客户现场进行巡检，发现有一个系统在进行sqlplus / as sysdba登录的时候特别缓慢。多次测试，最长时间可以达到近10s才能成功登录； 此时，对主机的cpu、内存、io以及网络等参数进行查看，发现使用率均不高，远远没有达到瓶颈，且在登录之前和登录之后，所有操作均非常顺滑，没有丝毫卡顿。 因此，判断该系统就是在sqlplus登录的时候才可能出现卡顿。 由于客户的业务并未反馈使用有问题，所以当时仅将该问题记录到日常错误处理日志中。 但是过了几天后，突然客户的业务使用人员说，他们
错误的用户名密码登录导致的数据库性能问题
cuchou5321的博客
06-02 331
从Oracle 11.1开始，错误的用户名密码登录可能会导致在数据库层面看到显著的“row cache lock”等待。 很多用户认为这是一个bug，而实际上这是一个数据库保护机制。 Oracle的sqlplus工具会在3次...
sqlplus登录缓慢的解决
bisal的专栏
12-21 1856
sqlplus登录Oracle数据库出现缓慢或者错误的原因可能很多，例如曾经碰到的，《登录缓慢的诡异问题》、《sqlplus登录报ORA-06502错误的问题排查和解决》，最近碰到了另外...
Oracle sqlplus连接数据库缓慢问题
dbhang的博客
09-16 1275
问题描述： 新安装的数据库发现sqlplus本地登录以及lsnrctl查看监听状态都异常卡顿 最终定位原因nameserver 配置错误，使用sqlplus连接时，需要根据/etc/resolv.conf去解析，当解析失败达到超时时间后才可以连接。 [root@dgpridb ~]# cat /etc/resolv.conf # Generated by NetworkManager #domain lan #search lan #nameserver 192.168.199.1 解决： 注释掉/et
[转自Oracle官方中文博客]sqlplus 登录时快时慢问题诊断
msdnchina的专栏@JiNan,ShanDong
01-17 809
sqlplus 登录时快时慢问题诊断
oracle数据库等不进去,oracle连接一直等待也不报错的有关问题
weixin_29798025的博客
04-04 1059
oracle连接一直等待也不报错的问题今天测试服务器上的程序访问数据库出现了异常，取不到数据了。而我在本地通过sqldevelper却可以访问，说明oracle实例可以正常工作，而当我关掉本地连接再去创建新连接的时候，出现了连接不上，也不报错的状态。实例正常，而不能连接，说明监听进程出了问题。因为每个新的连接请求，专用服务器都会为其创建专有的进程。基于这样的知识，进行了简单的操作。停止监听：lsn...
oracle sqlplus登录慢,[转自Oracle官方中文博客]sqlplus 登录时快时慢问题诊断
weixin_31725659的博客
04-03 201
+ sqlplus.trc11114 1468996741.620272 execve("/u01/app/oracle/product/11.2.0/bin/sqlplus", ["sqlplus", "system/spring"], [/* 29 vars */]) = 0...............11114 1468996741.849734 read(11, 11115 14689...
strace解决sqlplus登陆缓慢的问题一例
crc89714的博客
01-05 400
公司一台数据库测试服务器，某天开始sqlplus登陆缓慢，要卡四五秒才能登陆成功，而且是sqlplus / as sysdba 感觉问题排查无法下手，又不是什么大问题，库也不重要，一直没有去管 今天闲来无事，决定着...
Oracle SQLPlus登录方法与安全注意事项
"讲解SQLPLUS在Linux或Unix系统上的登录方式以及安全注意事项" 在Oracle数据库管理中，SQL*Plus是常用的命令行工具，用于交互式地访问数据库。本文将探讨两种SQL*Plus登录方法及其安全问题，主要针对Linux或Unix...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值