I'm using fastexport utility with Oracle Data Integrator to generate a delimited file. The full process takes almost two minutes. When I'm looking at the log file, the two minutes are spent on the database connection :
0001 .LOGTABLE xxxxxxx.FEXPLogTable; 0002 .LOGON xxxxxx/xxxxxxx,; **** 18:19:25 UTY8400 Teradata Database Release: 12.00.02.40 **** 18:19:25 UTY8400 Teradata Database Version: 12.00.02.40 **** 18:19:25 UTY8400 Default character set: ASCII **** 18:19:25 UTY8400 Current RDBMS has UDT support **** 18:19:25 UTY8400 Current RDBMS has Large Decimal support **** 18:19:25 UTY8400 Maximum supported buffer size: 1M **** 18:19:25 UTY8400 Data Encryption supported by RDBMS server **** 18:19:25 UTY6211 A successful connect was made to the RDBMS.
Do you have any idea why the connection takes two minutes ? Has it ever happened to you before ? I know it can come from many reasons, but who knows ... if someone can help, thanks in advance !