RAC 一个节点，5个小时产生了70多个G的trace ，把oracle目录撑满了

最新推荐文章于 2023-05-23 11:54:30 发布

coujiongyong0208

最新推荐文章于 2023-05-23 11:54:30 发布

阅读量170

点赞数

文章标签：数据库操作系统

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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29371470/viewspace-1062589/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29371470/viewspace-1062589/