小宝的家

[code="java"] stmt.execute( "begin dbms_monitor.session_trace_enable(waits=>TRUE); end;" );[/code]在做jdbc sql 操作前，先执行这个用于对等待事件的sql 跟踪(dbms_monitor 10g以上才行)9i用[code="java"]alter session set ev...

oracle jdbc 类关系图

[code="java"]class BenchmarkIntermittentCommits{ public static void main( String[] args ) throws Exception { Connection conn = null; try { conn = JDBCUtil.getConnection...

[code="java"]class DemoPrefetch{ public static void main(String[] args) { int connLevelDefaultPrefetch = 5; int stmtLevelFetchSize = 20; int rsetLevelFetchSize = 50; ...

[code="java"]class DemoParse { public static void main(String args[]) throws Exception { Connection conn = null; PreparedStatement pstmt = null; PreparedStatement pstmt1 = null; Re...