Friday, September 01, 2006

Profile Option controlled Database SQL Trace for Oracle Applications User / Responsibility

For Oracle Applications tracing User/forms to database trace files in user_dump_dest (udump): System Admin > Profile > System At User level set profile option: Initialization SQL Statement - Custom Value:

BEGIN FND_CTL.FND_SESS_CTL('','','TRUE','TRUE','',''); END;
Or if you also want to have the user name in the file name (replace OPERATIONS with your username):
BEGIN FND_CTL.FND_SESS_CTL('','','TRUE','TRUE','','ALTER SESSION SET TRACEFILE_IDENTIFIER = OPERATIONS MAX_DUMP_FILE_SIZE = 5000000 EVENTS ='||''''||' 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');END;
Voila!

2 comments:

Mike said...

Great! Thanks for sharing! Let me try this query. I hope that it will work great for me..Thanks Gareth!
sap test

Tani said...

INCREDIBLE! It seems like informative blog. I can see there is quite informative topics. I will certainly go for it.

oracle r12 documentation