Re: Can someone help using trcsess utility

From: Balakrishna Y <krishna000_at_gmail.com>
Date: Wed, 5 Aug 2009 20:39:05 -0700
Message-ID: <e53436b70908052039i482d87acm4d9e2b7d2ed6c02c_at_mail.gmail.com>

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:39:05 CDT