产生大量trc文件
os:hp-ux 11.31
oracle:10.2.0.4
最近整了个测试库,环境如上。
不过发现$oracle_base/admin/instance_name/bdump下面有很多trc文件,大概一分钟会产生一个文件,如下:
-rw-r----- 1 oracle oinstall 512 May 25 13:40 test_ora_25809.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:40 test_ora_25811.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:40 test_ora_25831.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:40 test_ora_25833.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:40 test_ora_25837.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:42 test_ora_25997.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:43 test_ora_26024.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:44 test_ora_26047.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:46 test_ora_26168.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:47 test_ora_26186.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:48 test_ora_26205.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:51 test_ora_26394.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:52 test_ora_26415.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:53 test_ora_26434.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:54 test_ora_26497.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:55 test_ora_26581.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:57 test_ora_26690.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:58 test_ora_26708.trc
-rw-r----- 1 oracle oinstall 512 May 25 13:59 test_ora_26734.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:00 test_ora_26753.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:00 test_ora_26755.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:00 test_ora_26814.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:02 test_ora_26872.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:04 test_ora_26962.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:05 test_ora_27036.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:08 test_ora_27127.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:09 test_ora_27157.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:10 test_ora_27218.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:11 test_ora_27311.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:12 test_ora_27377.trc
-rw-r----- 1 oracle oinstall 512 May 25 14:13 test_ora_27396.trc
而且内容都一样的,如下:
$ more test_ora_27036.trc
/var/u01/app/oracle/admin/test/bdump/test_ora_27036.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /var/u01/app/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: rx6600
Release: B.11.31
Version: U
Machine: ia64
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 27036, image: oracle@rx6600
Ioctl ASYNC_CONFIG error, errno = 1
查了metalink后,说可以设置这两个参数,可以停止产生trc文件
disk_asynch_io=FALSE(TRUE)
filesystemio_options=none (asynch)
结果果然不产生trc文件。
不过我想知道为什么我不能设置为异步呢,难道我的os不支持异步?oracle建议保持默认值的。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15037413/viewspace-605646/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15037413/viewspace-605646/