RE: Can someone help using trcsess utility

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Wed, 5 Aug 2009 22:55:57 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF01514B68_at_WIN02.hotsos.com>

That means that CLIENT ID isn't being set within your application so you can't use client ID as a parameter for trcsess.  

I think the command you want to use is something like:  

trcsess output=vp_all.trc *vp42660.trc  

This will combine all the trace files with vp42660 at the end of the name together into one trace file.  

---

Ric Van Dyke

Hotsos Enterprises

---

 

Hotsos Symposium

March 7 - 11, 2010

Be there.    

---

From: Balakrishna Y [mailto:krishna000_at_gmail.com] Sent: Wednesday, August 05, 2009 11:39 PM To: Ric Van Dyke
Cc: oracle-l_at_freelists.org
Subject: Re: Can someone help using trcsess utility  

Hi,

I dont have any client id as such in those trace files , but i could see this in the raw trace files.

• 2009-08-06 08:55:12.709
• ACTION NAME:(8421) 2009-08-06 08:55:12.693
• MODULE NAME:(fnd.framework.navigate.server.OANavigatePortletA) 2009-08-06 08:55:12.693
• SERVICE NAME:(SSBUAT2) 2009-08-06 08:55:12.693
• SESSION ID:(3839.352) 2009-08-06 08:55:12.693

We have oracle applications R12 and i have set 10046 level 12 event for one user . In UDUMP path , i have all these files

-rw-r--r-- 1 oracle dba 202679 Aug 05 16:01
ssbuat2_ora_1269822_TCS_SDS_CR49694978.txt
-rw-r--r-- 1 oracle dba 1669 Aug 06 08:55
ssbuat2_ora_1499342.trc
-rw-r--r-- 1 oracle dba 1798 Aug 06 08:55
ssbuat2_ora_1204398.trc
-rw-r--r-- 1 oracle dba 167362 Aug 06 08:55
ssbuat2_ora_1499342_yb42703.trc
-rw-r--r-- 1 oracle dba 1662 Aug 06 08:55
ssbuat2_ora_1417410.trc
-rw-r--r-- 1 oracle dba 1626 Aug 06 08:55
ssbuat2_ora_1527836.trc
-rw-r--r-- 1 oracle dba 480841 Aug 06 08:56
ssbuat2_ora_1527836_yb42703.trc
-rw-r--r-- 1 oracle dba 179896 Aug 06 09:01
ssbuat2_ora_1417410_yb42703.trc
-rw-r--r-- 1 oracle dba 69198 Aug 06 09:02
ssbuat2_ora_1204398_yb42703.trc
-rw-r--r-- 1 oracle dba 0 Aug 06 09:03 test.trc

I am trying to combine all the trace files which has (yb42703) but still it generates 0 size trace file with sessionid this time .

Regards

Bala

On Wed, Aug 5, 2009 at 5:54 AM, Ric Van Dyke <ric.van.dyke_at_hotsos.com> wrote:

Is that client ID in those trace files?  

Check the raw trace files for lines like:

• CLIENT ID:( vvp42660)

Are those trace files 10046 traces?  

The trcsess utility only works on 10046 trace files.  

---

Ric Van Dyke

Hotsos Enterprises

---

 

Hotsos Symposium

March 7 - 11, 2010

Be there.    

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Balakrishna Y Sent: Wednesday, August 05, 2009 8:30 AM To: oracle-l_at_freelists.org
Subject: Can someone help using trcsess utility  

Hi all,

I have below trace files in udump as

kiran_ora_4714776_vvp42660.trc
kiran_ora_1638558_vvp42660.trc
kiran_ora_4571498_vvp42660.trc
kiran_ora_5574948_vvp42660.trc

I am trying to merge all this trace files using trcsess but this generates 0 size output file. Dont really understand why ??

trcsess output=vvp.trc clientid=vvp42660

Regards

Bala  

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 05 2009 - 22:55:57 CDT