Hi,
i´m a problem with oracle 9.2 / Listener in Solaris 10. When i
connect direct on oracle it´s ok but when i try to connect using port
1100 on listener the connection is very slow, see truss command that i
did in sqlplus xxx/[EMAIL PROTECTED]:
26366: 0.2730 so_socket(PF_INET, SOCK_STREAM, IPPROTO_IP, "", SOV_DEFAULT) = 8
26366: 0.2738 connect(8, 0xFFFFFFFF7FFF6284, 16, SOV_DEFAULT) = 0
26366: 0.2743 getsockname(8, 0xFFFFFFFF7FFF6284, 0xFFFFFFFF7FFF6294,
SOV_DEFAULT) = 0
26366: 0.2745 setsockopt(8, tcp, TCP_NODELAY, 0xFFFFFFFF7FFF63F4, 4,
SOV_DEFAULT) = 0
26366: 0.2764 fcntl(8, F_SETFD, 0x00000001) = 0
26366: 0.2768 brk(0x1003BD570) = 0
26366: 0.2770 brk(0x1003C1570) = 0
26366: 0.2791 access("/pcvrdi/oracle/product/920/lib/libnk59.so", F_OK) = 0
26366: 0.2802 access("/pcvrdi/oracle/product/920/lib/libngss9.so",
F_OK) Err#2 ENOENT
26366: 0.2805 access("/pcvrdi/oracle/product/920/lib/libnnts9.so",
F_OK) Err#2 ENOENT
26366: 0.2808 access("/pcvrdi/oracle/product/920/lib/libnrad9.so", F_OK) = 0
26366: 0.2815 sigaction(SIGPIPE, 0xFFFFFFFF7FFF65F0, 0xFFFFFFFF7FFF6718) = 0
26366: 0.2822 getpid() = 26366 [26365]
26366: 0.2828 write(8, "\0 :\0\001\0\0\001 801 ,".., 58) = 58
26366: 0.2831 write(8, "\0F3\0\006\0\0\0\0\0 ( D".., 243) = 243
26366: read(8, 0x1003BF926, 2064) (sleeping...)
<------------------------------------------------ THIS
26366: 49.5211 read(8, "\0\b\0\0\v\0\0\0", 2064) = 8
26366: 49.5225 write(8, "\0 :\0\001\0\0\001 801 ,".., 58) = 58
26366: 49.5229 write(8, "\0F3\0\006\0\0\0\0\0 ( D".., 243) = 243
26366: 49.5233 read(8, "\0 \0\002\0\0\001 8\f01".., 2064) = 32
26366: 49.5238 getpid() = 26366 [26365]
26366: 49.5241 write(8, "\09C\0\006\0\0\0\0\0DEAD".., 156) = 156
26366: 49.5244 read(8, "\07F\0\006\0\0\0\0\0DEAD".., 2064) = 127
26366: 49.5254 sigaction(SIGTSTP, 0xFFFFFFFF7FFFB680, 0xFFFFFFFF7FFFB7A8) = 0
26366: 49.5257 fstat(0, 0xFFFFFFFF7FFFB870) = 0
26366: 49.5260 ioctl(0, TCGETA, 0xFFFFFFFF7FFFB7AC) = 0
26366: 49.5263 stat("/dev/tty", 0xFFFFFFFF7FFFB740) = 0
26366: 49.5266 stat("/dev/console", 0xFFFFFFFF7FFFB740) = 0
26366: 49.5269 stat("/dev/conslog", 0xFFFFFFFF7FFFB740) = 0
26366: 49.5273 stat("/dev/syscon", 0xFFFFFFFF7FFFB740) = 0
I think do some dtrace script to look for all lock´s on system to
discovery the root of problem because the CPU/DISK/MEM it´s ok. Other
feature is that the listener process stay sleep all most time on
prstat.
There are some sugestion ?
--
+++++++++++++++++++++++++++++++++++++++++++++++
Wesley Naves de Faria
Analista de Suporte
SCSA - Sun Certified System Administrator for Solaris 10
SCNA - Sun Certified Network Administrator for Solaris 10
FreeBSD / OpenBSD / Linux
+++++++++++++++++++++++++++++++++++++++++++++++
_______________________________________________
dtrace-discuss mailing list
dtrace-discuss@opensolaris.org
