![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile1.png\")
<\/p>\nThe main use of enabling trace for a concurrent program comes during performance tuning.<\/p>\n
By examining a trace file, we come to know which query\/queries is\/are taking the longest<\/p>\n
time to execute, there by letting us to concentrate on tuning them in order to improve the<\/p>\n
overall performance of the program.<\/p>\n
The following is an illustration of how to Enable and View a trace file for a Concurrent \u00a0Program.<\/p>\n
<\/p>\n
Navigation: Application Developer–>Concurrent–>Program\u00a0<\/span><\/p>\n Check the Enable Trace Check box. After that go to that particular Responsibility and run the Concurrent Program.\u00a0<\/span><\/p>\n Check that the Concurrent Program has been completed successfully.\u00a0<\/span><\/p>\n The trace file by default is post fixed with oracle Process_id which helps us to identify which trace file belongs to which concurrent request. The below SQL Query returns the process_id of the concurrent request:<\/p>\n Select oracle_process_id from fnd_concurrent_requests where request_id=’2768335′<\/p>\n (This query displays Process Id)<\/p>\n The path to the trace file can be found in 2 ways<\/p>\n 1.Run the below query in the database:\u00a0<\/span><\/p>\n (This Query displays the path of trace file)<\/p>\n 2. Login As sysadmin<\/p>\n Navigation> OAM->OAM Setup->Site MAP->Monitoring->System Configuration-> Database Init.ora Setting.<\/p>\n Check out the value for Parameter user_dump_dest which is nothing but the trace file location.<\/p>\n The Trace File generated will not be in the readable format. We have to use TKPROF utility to convert the file into a readable format.<\/p>\n Run the below tkprof command at the command prompt.<\/p>\n TKPROF < Trace File_Name.trc> <Output_File_Name.out> SORT=fchela<\/p>\n A readable file will be generated from the original trace file which can be further<\/p>\n analyzed to improve the performance. This file has the information about the<\/p>\n parsing, execution and fetch times of various queries used in the program.<\/p>\n The main use of enabling trace for a concurrent program comes during performance tuning. By examining a trace file, we come to know which query\/queries is\/are taking the longest time to execute, there by letting us to concentrate on tuning them in order to improve the overall performance of the program. The following is an […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[44,45],"class_list":["post-961","post","type-post","status-publish","format-standard","hentry","category-sysadmin-and-aol","tag-tkprof","tag-trace"],"yoast_head":"\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile2.png\")
<\/p>\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile3.png\")
\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile4.png\")
<\/p>\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile5.png\")
<\/p>\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile6.png\")
<\/p>\nSELECT * FROM V$PARAMETER WHERE NAME='user_dump_dest'<\/code><\/p>\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile7.png\")
<\/p>\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile8.png\")
<\/p>\n![\"\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041411_1057_TraceFile9.png\")
<\/p>\n","protected":false},"excerpt":{"rendered":"