Use TCP Fast Open (TFO) to Connect Clients to Autonomous Database
If your application is sensitive to network latency and you want to decrease the network latency between your application and the database, you can enable TCP Fast Open (TFO).
Depending on the characteristics of your application, TFO connections can improve application performance by decreasing network latency for client connections.
- Prerequisites for TCP Fast Open (TFO) Connections
Lists the prerequisites to use TCP Fast Open (TFO) connections with Autonomous Database. - JDBC Thin Connections with TCP Fast Open
Describes the requirements to use JDBC Thin connections with TCP Fast Open (TFO) on Autonomous Database. - TCP Fast Open Connections with Python
Describes the requirements to use Python with TCP Fast Open (TFO) connections on Autonomous Database. - TCP Fast Open Connections with Oracle Call Interface Client for C or SQL*Plus Connections
Describes the requirements to use Oracle Call Interface Client with TCP Fast Open (TFO) to connect with C or SQL*Plus to Autonomous Database.
Parent topic: Connection and Networking Options and Features
Prerequisites for TCP Fast Open (TFO) Connections
Lists the prerequisites to use TCP Fast Open (TFO) connections with Autonomous Database.
To use TCP Fast Open (TFO) to connect to an Autonomous Database instance, the client application requires the following:
-
The client must run on a VM in Oracle Cloud Infrastructure.
-
One of the following must be true:
-
The Autonomous Database is on a private endpoint.
-
When the Autonomous Database is on a public endpoint, the routing rules between the client VM and the database must be configured so that the traffic goes through a Service Gateway.
See Access Autonomous Database with Service Gateway and Configure Network Access with Private Endpoints for more information.
-
-
The VM must be running on Linux. Supported platforms are: Oracle Linux x86_64 and Oracle Linux Arm (aarch64).
-
The following OS level kernel parameters must be set:
- As root user, set the following parameters:
sysctl -w net.ipv4.tcp_fastopen=5
sysctl -w net.ipv4.tcp_fastopen_blackhole_timeout_sec=0
Verify the OS level kernel parameter values:
cat /proc/sys/net/ipv4/tcp_fastopen 5 cat /proc/sys/net/ipv4/tcp_fastopen_blackhole_timeout_sec 0
- As root user, set the following parameters:
JDBC Thin Connections with TCP Fast Open
Describes the requirements to use JDBC Thin connections with TCP Fast Open (TFO) on Autonomous Database.
Assure that the client environment and client prerequisites are met. See Prerequisites for TCP Fast Open (TFO) Connections for more information.
To use JDBC with TCP Fast Open (TFO), perform the following steps:
TCP Fast Open Connections with Python
Describes the requirements to use Python with TCP Fast Open (TFO) connections on Autonomous Database.
Assure that the client environment and client prerequisites are met. See Prerequisites for TCP Fast Open (TFO) Connections for more information.
To use Python with TCP Fast Open (TFO), perform the following steps:
TCP Fast Open Connections with Oracle Call Interface Client for C or SQL*Plus Connections
Describes the requirements to use Oracle Call Interface Client with TCP Fast Open (TFO) to connect with C or SQL*Plus to Autonomous Database.
Assure that the client environment and client prerequisites are met. See Prerequisites for TCP Fast Open (TFO) Connections for more information.
You can enable TCP Fast Open (TFO) with either mTLS or TLS connections. See Secure Connections to Autonomous Database and Update Network Options to Allow TLS or Require Only Mutual TLS (mTLS) Authentication on Autonomous Database for more information.
To use Oracle Call Interface with TCP Fast Open (TFO), perform the following steps: