{"id":11531,"date":"2018-08-09T15:32:52","date_gmt":"2018-08-09T13:32:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/"},"modified":"2023-06-09T17:01:33","modified_gmt":"2023-06-09T15:01:33","slug":"using-oratcptest","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/","title":{"rendered":"Using Oratcptest"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server.
\nIn this blog I am going to show how to use this tool in a DataGuard environment.
\nI am using a DataGuard environment with following configuration.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
Configuration - PROD<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxAvailability<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>PROD_SITE1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PROD_SITE2 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>PROD_SITE3 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover: DISABLED<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 54 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL> show <\/code>database<\/code> 'PROD_SITE1'<\/code> LogXptMode;<\/code><\/div>\n
\u00a0\u00a0<\/code>LogXptMode = <\/code>'SYNC'<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> 'PROD_SITE2'<\/code> LogXptMode;<\/code><\/div>\n
\u00a0\u00a0<\/code>LogXptMode = <\/code>'SYNC'<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> 'PROD_SITE3'<\/code> LogXptMode;<\/code><\/div>\n
\u00a0\u00a0<\/code>LogXptMode = <\/code>'SYNC'<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The installation of Oratcptest is very simple. We just have to download on both servers the oratcptest.jar file from the oracle support site. Note that JRE 6 or higher is required. In my case I have JRE 8 on both servers<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n<\/td>\n
\n
\n
[oracle@primaserver oratcptest]$ java -version<\/code><\/div>\n
openjdk version <\/code>\"1.8.0_111\"<\/code><\/div>\n
OpenJDK Runtime Environment (build 1.8.0_111-b15)<\/code><\/div>\n
OpenJDK 64-<\/code>Bit<\/code> Server VM (build 25.111-b15, mixed mode)<\/code><\/div>\n
[oracle@primaserver oratcptest]$<\/code><\/div>\n
<\/div>\n
[oracle@standserver1 oratcptest]$ java -version<\/code><\/div>\n
openjdk version <\/code>\"1.8.0_181\"<\/code><\/div>\n
OpenJDK Runtime Environment (build 1.8.0_181-b13)<\/code><\/div>\n
OpenJDK 64-<\/code>Bit<\/code> Server VM (build 25.181-b13, mixed mode)<\/code><\/div>\n
[oracle@standserver1 oratcptest]$<\/code><\/div>\n
<\/div>\n
[oracle@standserver2 ~]$ java -version<\/code><\/div>\n
openjdk version <\/code>\"1.8.0_181\"<\/code><\/div>\n
OpenJDK Runtime Environment (build 1.8.0_181-b13)<\/code><\/div>\n
OpenJDK 64-<\/code>Bit<\/code> Server VM (build 25.181-b13, mixed mode)<\/code><\/div>\n
[oracle@standserver2 ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can invoke the help command to see all options available for the oratcptest<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[oracle@primaserver oratcptest]$ java -jar oratcptest.jar -help<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now we can assess the network bandwidth for our DataGuard. Note that I am using simple virtual machines. But the steps will be the same on real productions servers.
\nWe first have to determine the highest volume of redo log in my database. Following Oracle query can be used.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
select<\/code> thread#,<\/code>sequence<\/code>#,blocks*block_size\/1024\/1024 MB,(next_time-first_time)*86400 sec, blocks*block_size\/1024\/1024\/((next_time-first_time)*86400) <\/code>\"MB\/s\"<\/code> from<\/code> v$archived_log <\/code>where<\/code> ((next_time-first_time)*864000) <\/code>and<\/code> first_time <\/code>between<\/code>\u00a0 to_date(<\/code>'2018\/08\/09 08:00:00'<\/code>,<\/code>'YYYY\/MM\/DD HH24:MI:SS'<\/code>) <\/code>and<\/code> to_date(<\/code>'2018\/08\/09 11:00:00'<\/code>,<\/code>'YYYY\/MM\/DD HH24:MI:SS'<\/code>) <\/code>and<\/code> dest_id=2 <\/code>order<\/code> by<\/code> first_time;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0<\/code>THREAD#\u00a0 <\/code>SEQUENCE<\/code>#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SEC\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MB\/s<\/code><\/div>\n
---------- ---------- ---------- ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 124 .003417969\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9 .000379774<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 125 .271972656\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 184 .001478112<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 126 .001953125\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5 .000390625<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 127 11.3662109\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 915 .012422088<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 128 10.8466797\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6353 .001707332<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see that the highest value is .012422088 MB\/s. The goal is to see if our network bandwidth can support this rate.
\nAs we are using SYNC mode, the primary database will wait for a confirmation from standby databases that they have written the change to disk before informing the application of the commit success.
\nFor SYNC transport we then have to collect the Average redo write size which is calculated using following formula<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
Average=redo <\/code>size<\/code> \/ redo writes<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

These metrics can be obtained using an AWR report. In our case the value is<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
Average=15924844\/4015=3967<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now we are going to simulate SYNC writes over the network using Oratcptest. Note I need the location of my standby redo logs<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> member <\/code>from<\/code> v$logfile <\/code>where<\/code> type=<\/code>'STANDBY'<\/code>;<\/code><\/div>\n
<\/div>\n
MEMBER<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/PROD\/stredo01.log<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/PROD\/stredo02.log<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/PROD\/stredo03.log<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/PROD\/stredo04.log<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

From the standby server I can run following command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
[oracle@standserver1 oratcptest]$ java -jar oratcptest.jar -server -port=5555 -file=\/u01\/app\/oracle\/oradata\/PROD\/myoratcp.tmp<\/code><\/div>\n
OraTcpTest server started.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

From the primary server<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n<\/td>\n
\n
\n
[oracle@primaserver oratcptest]$ java -jar oratcptest.jar standserver1 -port=5555\u00a0 -write\u00a0 -mode=sync -length=3967 -duration=10s -interval=2s<\/code><\/div>\n
[Requesting a test]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message payload\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3967 bytes<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Payload content type\u00a0\u00a0 = RANDOM<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Delay <\/code>between<\/code> messages = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Number <\/code>of<\/code> connections\u00a0 = 1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Socket send buffer\u00a0\u00a0\u00a0\u00a0 = (system <\/code>default<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Transport mode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = SYNC<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Disk write\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = YES<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Statistics<\/code> interval\u00a0\u00a0\u00a0 = 2 seconds<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Test duration\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 10 seconds<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Test frequency\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Network Timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(1 Mbyte = 1024x1024 bytes)<\/code><\/div>\n
<\/div>\n
(14:26:16) The server <\/code>is<\/code> ready.<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Throughput\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Latency<\/code><\/div>\n
(14:26:18)\u00a0\u00a0\u00a0\u00a0\u00a0 1.124 Mbytes\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.375 ms\u00a0\u00a0 (disk-write 2.537 ms)<\/code><\/div>\n
(14:26:20)\u00a0\u00a0\u00a0\u00a0\u00a0 0.813 Mbytes\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4.668 ms\u00a0\u00a0 (disk-write 3.775 ms)<\/code><\/div>\n
(14:26:22)\u00a0\u00a0\u00a0\u00a0\u00a0 1.094 Mbytes\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.467 ms\u00a0\u00a0 (disk-write 2.773 ms)<\/code><\/div>\n
(14:26:24)\u00a0\u00a0\u00a0\u00a0\u00a0 1.004 Mbytes\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.778 ms\u00a0\u00a0 (disk-write 2.991 ms)<\/code><\/div>\n
(14:26:26)\u00a0\u00a0\u00a0\u00a0\u00a0 0.560 Mbytes\/s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6.779 ms\u00a0\u00a0 (disk-write 5.623 ms)<\/code><\/div>\n
(14:26:26) Test finished.<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Socket send buffer = 11700 bytes<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Avg<\/code>. throughput = 0.920 Mbytes\/s<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Avg<\/code>. latency = 4.126 ms (disk-write 3.280 ms)<\/code><\/div>\n
<\/div>\n
[oracle@primaserver oratcptest]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see that the Average throughput is 0.920 M\/s which is sufficient to handle our highest peak rate which is .012422088 MB\/s. We can also note the latency which includes the time to send the message to the server host, the optional disk write at the server host, and the acknowledgment back to the client process
\nIf we are using ASYNC mode the test will be like<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n<\/td>\n
\n
\n
[oracle@primaserver oratcptest]$ java -jar oratcptest.jar standserver1 -port=5555\u00a0\u00a0\u00a0 -mode=async -length=3967 -duration=10s -interval=2s<\/code><\/div>\n
[Requesting a test]<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Message payload\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 3967 bytes<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Payload content type\u00a0\u00a0 = RANDOM<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Delay <\/code>between<\/code> messages = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Number <\/code>of<\/code> connections\u00a0 = 1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Socket send buffer\u00a0\u00a0\u00a0\u00a0 = (system <\/code>default<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Transport mode\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = ASYNC<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Disk write\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Statistics<\/code> interval\u00a0\u00a0\u00a0 = 2 seconds<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Test duration\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 10 seconds<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Test frequency\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Network Timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(1 Mbyte = 1024x1024 bytes)<\/code><\/div>\n
<\/div>\n
(14:58:03) The server <\/code>is<\/code> ready.<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Throughput<\/code><\/div>\n
(14:58:05)\u00a0\u00a0\u00a0\u00a0 13.897 Mbytes\/s<\/code><\/div>\n
(14:58:09)\u00a0\u00a0\u00a0\u00a0\u00a0 5.193 Mbytes\/s<\/code><\/div>\n
(14:58:11)\u00a0\u00a0\u00a0\u00a0 40.007 Mbytes\/s<\/code><\/div>\n
(14:58:13)\u00a0\u00a0\u00a0\u00a0 21.475 Mbytes\/s<\/code><\/div>\n
(14:58:13) Test finished.<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Socket send buffer = 210600 bytes<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Avg<\/code>. throughput = 16.901 Mbytes\/s<\/code><\/div>\n
<\/div>\n
[oracle@primaserver oratcptest]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/strong>
\nIn this blog we have talked about Oratcptest which is a simple tool which can help to assess our network bandwidth. Oratcptest can help before performing Rman Backups, file copies, a DataGuard environment.
\nReference : Oracle Doc ID 2064368.1<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show how to use this tool in a DataGuard environment. I am using a DataGuard environment with […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[999,1423,107,209,1424],"type_dbi":[],"class_list":["post-11531","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard","tag-network-bandwidth","tag-network-latency","tag-oracle-12c","tag-oratcptest"],"acf":[],"yoast_head":"\nUsing Oratcptest - dbi Blog<\/title>\n<meta name=\"description\" content=\"DataGuard, , oracle 12c, network bandwidth, network latency,oratcptest\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Oratcptest\" \/>\n<meta property=\"og:description\" content=\"DataGuard, , oracle 12c, network bandwidth, network latency,oratcptest\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-09T13:32:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T15:01:33+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Using Oratcptest\",\"datePublished\":\"2018-08-09T13:32:52+00:00\",\"dateModified\":\"2023-06-09T15:01:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\"},\"wordCount\":394,\"commentCount\":0,\"keywords\":[\"DataGuard\",\"network bandwidth\",\"network latency\",\"Oracle 12c\",\"oratcptest\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\",\"name\":\"Using Oratcptest - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-08-09T13:32:52+00:00\",\"dateModified\":\"2023-06-09T15:01:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"DataGuard, , oracle 12c, network bandwidth, network latency,oratcptest\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Oratcptest\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using Oratcptest - dbi Blog","description":"DataGuard, , oracle 12c, network bandwidth, network latency,oratcptest","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/","og_locale":"en_US","og_type":"article","og_title":"Using Oratcptest","og_description":"DataGuard, , oracle 12c, network bandwidth, network latency,oratcptest","og_url":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/","og_site_name":"dbi Blog","article_published_time":"2018-08-09T13:32:52+00:00","article_modified_time":"2023-06-09T15:01:33+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Using Oratcptest","datePublished":"2018-08-09T13:32:52+00:00","dateModified":"2023-06-09T15:01:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/"},"wordCount":394,"commentCount":0,"keywords":["DataGuard","network bandwidth","network latency","Oracle 12c","oratcptest"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/","url":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/","name":"Using Oratcptest - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-08-09T13:32:52+00:00","dateModified":"2023-06-09T15:01:33+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"DataGuard, , oracle 12c, network bandwidth, network latency,oratcptest","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/using-oratcptest\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Oratcptest"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11531"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11531\/revisions"}],"predecessor-version":[{"id":25777,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11531\/revisions\/25777"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11531"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}