This feature optionally suppresses the ratio expansion from SQL Server database to Oracle database involving multi-byte character set.

By default, Oracle gateways assume the worst ratio to prevent data being truncated or insufficient buffer size situation. However, if you have specific knowledge of your SQL Server database and do not want the expansion to occur, you can specify HS_KEEP_REMOTE_COLUMN_SIZE parameter to suppress the expansion. Refer to Initialization Parameters for more detail.