环境准备

设置参数

ENABLE_SQL_TRACE=true
ENABLE_SQL_TRACE_WAIT=true
ENABLE_TIME_STAT=true

创建表空间

CREATE TABLESPACE system2 DATAFILE 'ceshi.data' SIZE 2m AUTOEXTEND ON
NEXT 2m;

创建表

create table t(a int, b varchar(50), c varchar(50), d varchar(50), e
varchar(50), f varchar(50), g varchar(50), h varchar(50), i varchar(50),
j varchar(50), k varchar(50),l varchar(50), m varchar(50), n
varchar(50))tablespace system2;

数据插入程序

public class Test {
    private static String url ="jdbc:oscar://localhost:2003/anli";
    public static void main(String[] args) {
        Test ioTest = new Test();
        try {
            Connection conn = ioTest.getConnection();
            //设置为手动提交
            conn.setAutoCommit( false);
            long start = System. currentTimeMillis ();
            Statement st = conn.createStatement();
            //循环插入
            for (int i = 0; i < 100000; i++) {
            st.executeUpdate("insert into t
                             values("+12.0+",'asdasdadasdasdasdasdsadeweweweweweeweweweewwewe'," +
                             " 'weweweweeeeeewewewewewewwewewewewwewewewewe', " +
                             "'wewewewewewewewewewewewewewewewewewewwewweew'," +
                             "'sdfsfsffsdfdfsfsfsfdsdfdfsfdsfsdfsfsdfsddfdfds', " +
                             " 'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf'," +
                             " 'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             " 'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             "'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             " 'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             "'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             " 'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             "'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf', " +
                             " 'sdfasdfasdfsafdasdfafsdfsdfsdfsdsdsdf')");
            conn.commit();
        }
        long end = System. currentTimeMillis ();
        System. out.println(end - start);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    /**
    * 创建连接
    * @return
        * @description
        * **@version** 1.0
        * **@author** whw
    * @update 2012-5-23 下午1:    16:        29
        */
    public Connection getConnection() {
        Connection con = null;
        try {
            Class. forName ("com.oscar.Driver");
            con = DriverManager. getConnection (url, "sysdba", "szoscar55");
        } catch  (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return con;
    }
}