Resized overflow buffer to xxxK (for xxxxK LWN) in trace file

From: Guang Mei <GuangMei_at_crd.com>
Date: Wed, 26 Sep 2007 17:06:00 -0400
Message-ID: <BB2F960B8F4F7C40A09F44F50CF40A782A9CD9@mail3.crd.com>

We are running oracle 10.2.0.1 on Solaris 5.10    

SQL> select * from v$version;  

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Solaris: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production    

But in udump directory, I see lots of small trace files, and typically it has something like  

• 2007-09-19 08:59:23.924
• ACTION NAME:() 2007-09-19 08:59:23.917
• MODULE NAME:(SQL*Plus) 2007-09-19 08:59:23.917
• SERVICE NAME:(DS10ORA2) 2007-09-19 08:59:23.917
• SESSION ID:(1000.8924) 2007-09-19 08:59:23.917

Resized overflow buffer to 10240K (for 9352K LWN)

Resized overflow buffer to 9216K (for 8235K LWN)

Resized overflow buffer to 9216K (for 8310K LWN)

• 2007-09-19 09:02:28.434

Resized overflow buffer to 10240K (for 9352K LWN)

Resized overflow buffer to 9216K (for 8235K LWN)

Resized overflow buffer to 9216K (for 8310K LWN)    

Does anyone know why I am getting these? I am curious what the root cause is.

Thanks.  

Guang

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 26 2007 - 16:06:00 CDT