OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » FND_CONCURRENT_DEBUG

Home » Applications » Oracle Fusion Apps & E-Business Suite » FND_CONCURRENT_DEBUG_INFO

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FND_CONCURRENT_DEBUG_INFO [message #139756]

Thu, 29 September 2005 08:24

alanm
Messages: 284
Registered: March 2005

Senior Member

hi all,
this table FND_CONCURRENT_DEBUG_INFO has > 53 million rows.
can someone tell me what the table is used for and if I can truncate it. Also how is information written to the table.

best regards

Alan.

Report message to a moderator

Re: FND_CONCURRENT_DEBUG_INFO [message #139792 is a reply to message #139756]

Thu, 29 September 2005 10:48

mchittib
Messages: 87
Registered: September 2005

Member

why do u want to truncate it?

If you want take a backup of that table, truncate it, do your process, view the results and restore the original table back.

Report message to a moderator

Re: FND_CONCURRENT_DEBUG_INFO [message #139814 is a reply to message #139756]

Thu, 29 September 2005 13:15

alanm
Messages: 284
Registered: March 2005

Senior Member

Hi,
what information is stored in the table?
is it used by any reports etc? if not then can i just on a regular basis truncate the tabel

ty

Alan

Report message to a moderator

Re: FND_CONCURRENT_DEBUG_INFO [message #139819 is a reply to message #139756]

Thu, 29 September 2005 13:34

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Check out MetaLink note 105133.1, about 80% of the way down the page. (Search on FND_CONCURRENT_DEBUG_INFO.)

Report message to a moderator

Re: FND_CONCURRENT_DEBUG_INFO [message #140226 is a reply to message #139756]

Sun, 02 October 2005 23:57

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

This table will only be used if an Oracle developer is debugging
certain low level concurrent processing mechanisms.
YOu can truncate data from this table.

Report message to a moderator

Re: FND_CONCURRENT_DEBUG_INFO [message #140227 is a reply to message #139756]

Sun, 02 October 2005 23:59

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

Set the profile option 'Concurrent:Debug Flags' to 'TCTM1' at the site level. This will cause transactions to make debug entries in the FND_CONCURRENT_DEBUG_INFO table. Truncate this table before running a tranasction, then select the entries from the table. Also, starting the managers with diag=Y will produce more information in the transaction manager logfile.

Report message to a moderator

Previous Topic:	Implementation methodlogy and best practices
Next Topic:	Valid character set for Oracle Apps Form's fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 02:04:19 CDT 2024