From a cursory search I didn't see that this was something that could be set except via the connection or system property (-Doracle.jdbc.useFetchSizeWithLongColumn=true), so we'll just document this for now.

Improve Oracle metadata import ------------------------------ Key: TEIID-5234 URL: https://issues.jboss.org/browse/TEIID-5234 Project: Teiid Issue Type: Enhancement Components: JDBC Connector Reporter: Ramesh Reddy Assignee: Steven Hawkins It has been verified that if import uses the following URL property {code} useFetchSizeWithLongColumn=true {code} it significantly improves the metadata load process, especially when there are a large number of tables in a schema. See doc [1] Teiid should either somehow enforce or document this. [1] https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/Oracle...