oracle表日志影响速度嘛,Oracle 的listener.log 日志超过4G导致SQL速度极慢，监听命令能执行要10min。...

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

Fatal NI connect error 12570, connecting to:

(LOCAL=NO)

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

VERSION INFORMATION:

TNS for 64-bit Windows: Version 11.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

Time: 21-2月 -2014 13:14:08

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

Tracing not turned on.

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

Tns error struct:

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

ns main err code: 12570

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

TNS-12570: TNS: 包阅读程序失败

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

ns secondary err code: 12560

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

nt main err code: 0

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

nt secondary err code: 0

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11'>

nt OS err code: 0

type='UNKNOWN' level='16' host_id='WIN-LO2BM3SDT1A'

host_addr='fe80::11c3:7366:5a5c:609a%11' pid='4748'>

opiodr aborting process unknown ospid (4748) as a result of ORA-609

查看上面的alter日志可以一个问题就是【TNS-12570: TNS: 包阅读程序失败】

找了好久都没有什么头绪，结果看到$ORACLE_HOME/diag\tnslsnr\WIN-LO2BM3SDT1A\listener\trace   目录下

有一个listener.log 日志文件大小到4G多，找了下windows 文件系统的配置如下，这个文件明显达到极限(客户服务器为NTFS 64位 txt文件可以支持到4G)，

Windows下可以使用下面的命令来控制

lsnrctl set log_status off

rename listener.log listener.old

lsnrctl set log_status on

理论上硬盘还剩多少就可以保存多大的文件

NTFS(Windows)：支持最大分区2TB，最大文件2TB

FAT16(Windows)：支持最大分区2GB，最大文件2GB

FAT32(Windows)：支持最大分区128GB，最大文件4GB

HPFS(OS/2)：支持最大分区2TB，最大文件2GB

EXT2和EXT3(Linux)：支持最大分区4TB，最大文件2GB

JFS(AIX)：支持最大分区4P(block size=4k)，最大文件4P

XFS(IRIX)：这是个正经的64位的文件系统，可以支持9E(2的63次方)的分区