Total System Global Area 286755168 bytes Fixed Size 731488 bytes Variable Size 167772160 bytes Database Buffers 117440512 bytes Redo Buffers 811008 bytes Database mounted. Database opened. SQL> connect eygle/eygle Connected. SQL> show parameter disable
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _disable_logging boolean TRUE
测试创建100万数据表:
SQL> create table test as select * from dba_objects where 1=0;
Table created.
SQL> set timing on SQL> begin 2 for i in 1 .. 10000 loop 3 insert into test select * from dba_objects where rownum < 101; 4 commit; 5 end loop; 6 end; 7 /
PL/SQL procedure successfully completed.
Elapsed: 00:00:40.46 SQL> truncate table test;
Table truncated.
Elapsed: 00:00:52.72
大约时间用了40秒.
再看正常日志生成下:
SQL> connect / as sysdba Connected. SQL> alter system set "_disable_logging"=false;
Total System Global Area 286755168 bytes Fixed Size 731488 bytes Variable Size 167772160 bytes Database Buffers 117440512 bytes Redo Buffers 811008 bytes Database mounted. Database opened. SQL> show parameter disable
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ _disable_logging boolean FALSE
SQL> connect eygle/eygle Connected. SQL> set timing on SQL> SQL> begin 2 for i in 1 .. 10000 loop 3 insert into test select * from dba_objects where rownum < 101; 4 commit; 5 end loop; 6 end; 7 /
BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for Solaris: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production
环境：
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
请教大师，隐藏参数_disable_logging通过show parameter 也能显示出来，我的咋不行呢？
环境：
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
因为你没有设置这个参数，设置之后在参数文件中存在才能show出来。
建议你不要乱试，看过了就算了吧:)