使用profile的Idle time时要注意。

有未提交的事务依然断开，比较恐怖，断开时自动做了提交，其实就相当于做了disconnect[@more@]

SQL> select * from t1;

未选定行

SQL> insert into t1 values(1,'a');

已创建 1 行。

SQL> select * from t1;
select * from t1
*
第 1 行出现错误:
ORA-02396: 超出最大空闲时间, 请重新连接

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:>sqlplus c/c@abc

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 3月 19 14:21:53 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from t1;

ID NAME
---------- ----------
1 a

--我们发现有事务依然断开，比较恐怖，断开时自动做了提交
SQL> insert into t1 values(2,'b');

已创建 1 行。

SQL> disconnect
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开
SQL> exit

C:>sqlplus c/c@abc

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 3月 19 14:23:15 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from t1;

ID NAME
---------- ----------
1 a
2 b

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1019031/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1019031/