Oracle Database Discussions

Hi,

In one of our DBs SQLplus connection time varies a lot.Some times it's fast,takes less than 3 seconds to connect but most of the time it takes a long time to connect.

This is true whether I connect sqlplus "/as sysdba" locally or sqlplus user@dbname.

Database version in 10.2.0.4 and it's running on Solaris 10 Server.

We have other databases running on same server but we didn't find any issues there.

When I did a truss of the sqlplus I found that a jump in time takes place at following line

-----------------------------------
0.8975 ioctl(9, _IOWRN('i', 20, 8), 0xFFFFFFFF7FFF9530) = 0
0.8978 ioctl(9, SIOCGIFFLAGS, 0x1001B7ED0) = 0
0.8980 ioctl(9, SIOCGIFFLAGS, 0x1001B7EF0) = 0
0.8982 ioctl(9, SIOCGIFADDR, 0x1001B7EF0) = 0
0.8985 ioctl(9, SIOCGARP, 0xFFFFFFFF7FFF950C) = 0
0.8989 write(10, "03 w\0\006\0\0\0\0\003 s".., 887) = 887
read(11, 0x1001CF216, 2064) (sleeping...)
4.9681 read(11, "03F4\0\006\0\0\0\0\0\b\0".., 2064) = 1012
4.9699 open("/ap01/apps/oracle/product/10.2.0.4/rdbms/mesg/oraus.msb", O_RDONLY) = 12
4.9703 fcntl(12, F_SETFD, 0x00000001) = 0
4.9705 lseek(12, 0, SEEK_SET) = 0
4.9707 read(12, "1513 "011303\t\t\0\0\0\0".., 256) = 256
4.9710 lseek(12, 512, SEEK_SET) = 512
----------------------------------------------------------------------------------------

I did a relink of oracle home and that didn't help.

If you can give your thoughts on this issue,it will be really helpful.

Thanks...
Sajan