Hello. I found the below result by monitoring my system with JENNIFER.

[Problem 1] In the X-VIEW, ExecuteThread: ‘42’ for queue: ‘weblogic.kernel.Default’ GET-CONNECTION DataSource.getConnection() [577912ms] —> (1) SOCKET-ISTREAM Socket[addr=192.168.5.23, port=1521, localport=44201] SOCKET-OSTREAM SOCKET[addr=192.168.5.23, port=1521, localport=44201] GET-CONNECTION DataSource.getConnection() [2ms] SQL-PREPARSE_STMT{0}[UPDATE …. ]

In the getConnection stage, execution time has taken a lot of time and finally application failed to get connection. In my opinion, it is because of accessing to Invalid Connection. Then, why Invalid Connection occurred?

Under the real monitoring environment, initial value of WAS Connection Pool is 50 but the number linked to JDBC driver in DB is 20.

[Problem2] We have two web application servers which have same source and architecture. When I monitor them with JENNIFER, JDBC connection status of WAS1 is “connected” but I can’t see any input data about JDBC connection in case of WAS2. A strange thing is WAS 2 takes request as I see through X-View. But in X-view, the status is ‘No-Profile’. I use same WAS Connection Pool but why this problem happens?

[Question] In X-view, SQL-EXECUTE-QUERY{1} [23,345ms] param1: ..... FETCH [10/10] CLOSE CONNECTION

Q 1: FETCH [10/10] -> Does this mean that 10 of search data should be fetched? Or what does FETCH [281/291] mean? Are 281 applications among 291 fetched?

Q 2: Does ‘23,345ms’ mean execution time of SQL statement or fetch time? In DB, SQL execution time is not taken a lot of time. If it is fetch time, I can’t understand that fetch time of 10 applications is 23,345ms. It took too much time. These are all my questions and please answer for me.

As for the first question, it took more than 500 seconds in DataSource.getConnection(). At first, you need to check JDBC Connection is closed through JENNIFER. If this problem continues even though they are closed well, you need javacore. Did you check DB point through netstat? In JENNIFER, you have to count the number of OracleDriver object within JVM.

As for the second question, check LWST status and 6703 port is opened if there is firewall between WebLogic and Jennifer Server. (server_udp_lwst_call_stack_port) One more, remove # in enable_non_servlet_thread_jdbc_trace = true option of agent config and restart weblogic.

Answer 1 First figure means the number of fetched cases in the query and second figure is accumulated fetch cases in the thread. Answer 2 It is Query time.