RAC 一個節點，5個小時產生了70多個G的trace ，把oracle目錄撐滿了

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.