RAC 一个节点,5个小时产生了70多个G的trace ,把oracle目录撑满了
trace的内容:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, Real Application Clusters, Automatic Storage
Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0.3
home_1
System name: Linux
Node name: db02
Release: 2.6.18-238.12.2.0.2.el5
Version: #1 SMP Tue Jun 28 05:21:19 EDT
2011
Machine: x86_64
Instance name: edwnew2
Redo thread mounted by this instance: 2
Oracle process number: 150
Unix process pid: 7139, image: oracle@02.sceda.com
*** 2013-12-06 16:42:13.665
*** SESSION ID:(403.11297) 2013-12-06 16:42:13.665
*** CLIENT ID:() 2013-12-06 16:42:13.665
*** SERVICE NAME:(edwnew) 2013-12-06 16:42:13.665
*** MODULE NAME:(PL/SQL Developer) 2013-12-06
16:42:13.665
*** ACTION NAME:(SQL Window - create table
f_2_jt_evt_cust_calling_m_b compress f) 2013-12-06
16:42:13.665
===================================================
SYSTEM STATE (level=11, with short stacks)
------------
System global information:
processes:
base 0xa10f76ae8, size 1024, cleanup 0xa10f92b50
allocation:
free sessions 0xa5906c598, free calls (nil)
control
alloc errors: 0 (process), 0 (session), 0 (call)
PMON latch
cleanup depth: 0
seconds
since PMON's last scan for dead processes: 0
system
statistics:
0 OS CPU Qt wait time
1.
看看alert日志
2.
查看diag进程日志
应该是PL/SQL Developer连上去create table
有trace很大的,都要去分析
临时解决方案:
MAX_DUMP_FILE_SIZE specifies the maximum size of trace files
(excluding the alert file). Change this limit if you are concerned
that trace files may use too much space.
A numerical value for MAX_DUMP_FILE_SIZE specifies the maximum size
in operating system blocks.
A number followed by a K or M suffix specifies the file size in
kilobytes or megabytes.
The special value string UNLIMITED means that there is no upper
limit on trace file size. Thus, dump files can be as large as the
operating system permits.
——————————————————————————————————————————————