oracle_rac_application_continuity

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle_rac_application_continuity [2020/10/22 12:09] – andonovjoracle_rac_application_continuity [2020/10/22 12:13] (current) – andonovj
Line 277: Line 277:
 > # Use new 12.1 replay datasource > # Use new 12.1 replay datasource
 > datasource=oracle.jdbc.replay.OracleDataSourceImpl > datasource=oracle.jdbc.replay.OracleDataSourceImpl
 +</Code>
 +
 +That way, the application will be able to reconnect after interrupted connection:
 +
 +<Code:bash|Interrupted Connection>
 +[oracle@enode01 labs]$ ./runreplay.sh
 +######################################################
 +Connecting to
 +jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clus
 +ter01-
 +scan)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=actest.
 +example.com)))
 +# of Threads : 6
 +UCP pool size : 2
 +Thread think time : 20 ms
 +######################################################
 +2 active connections, avg response time from db 304 ms
 +2 active connections, avg response time from db 45 ms
 +2 active connections, avg response time from db 304 ms
 +2 active connections, avg response time from db 45 ms
 +2 active connections, avg response time from db 29 ms
 +2 active connections, avg response time from db 32 ms
 +2 active connections, avg response time from db 29 ms
 +2 active connections, avg response time from db 18 ms
 +2 active connections, avg response time from db 36 ms
 +... (Interupted connection)
 +2 active connections, avg response time from db 5962 ms
 +2 active connections, avg response time from db 98 ms
 +2 active connections, avg response time from db 61 ms
 +2 active connections, avg response time from db 72 ms
 +[oracle@enode01 labs]$
 +
 </Code> </Code>
  • oracle_rac_application_continuity.1603368584.txt.gz
  • Last modified: 2020/10/22 12:09
  • by andonovj