Connection Timeout

By default, the database connection to Autonomous AI Database disconnects after 120 seconds of being idle or processing an operation. This is due to the server side SQLNET.ORA having a RECV_TIMEOUT = 120. So, a DDL or DML operation that takes longer than 2 minutes (120 seconds) will fail.

To override this behavior, you must set RECV_TIMEOUT on the client side SQLNET.ORA file to a higher value.

The RECV_TIMEOUT parameter can be used in the connect string. So they would not modify the SQLNET.ORA file, but instead add it as part of the connection string.

(DESCRIPTION =
   (ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)(CONNECT_TIMEOUT=10)(RECV_TIMEOUT=6000)
   (CONNECT_DATA=(SERVICE_NAME=myservice))
)