Connection slow into 10.2.0.4 database on AIX 5.3
Hi
I found few issues been launched running Oracle on AIX.
We having slow issue to get connected into database. But it happend at certain time. I did test in DB developement server and production DB server. This happen although one user access into database.
I did simulation by do sqlplus straight in DB server. using system id. Repaeting the sqlplus command few times and until one stage the time taken is longer. If normal it took about 2 second to get the SQL>, but at that time it went to 10 - 15 seconds. The basic VMM configuration suggested have been done. Both servers got high memory size. Fast CPUs.
Whatelse do I need to check ?
Please advice