Oracle JDBC Thin Connections
Version 12.1.0.1

General Information
Note: The following advice is given not to teach scripting in PERL but rather to establish, in writing, some best practices for developers and DBAs using PERL to work with an Oracle database.
Array size Optimize the array size with real-world tests using your database and your application. Do not accept the default.
Connect Timeout set through SQL*Net property CONNECT_TIMEOUT See SQL*Net Link Below
Read Timeout set through READ_TIMEOUT. Do not use as a query-timeout See SQL*Net Link Below
Query Timeout User statement.cancel or Statement.setQueryTimeout
SDU passed through the connect string jdbc:oracle:thin:@(DESCRIPTION ... (SDU=<value>)...)
jdbc:oracle:thin:@(DESCRIPTION ...(SDU=32767)...)

Related Topics
SQL*Net
Tuning

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved