Oracle JDBC Thin Connections
Version 11.2.0.3

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.
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-2013 Daniel A. Morgan All Rights Reserved