Oracle Project Foundation - Version 11.5.10.2 and later: Projects TKPROF Trace - How To Resolve ORA-00955 Error in CREATE TABLE of EXPLAIN PLAN table: APPS.prof$plan
Up to and including Oracle 10g the tool that is generally used to analyse trace files is calledtkprof. This tool formats the trace files that have been generated into a more readable format. Understanding the trace file format seems daunting on first inspection. A good source for details on t...
Oracle Database provides a tool calledtkproffor this very purpose. It accepts a raw trace file and produces a file with the trace file data in a readable format. Here is how you would use tkprof on a raw trace file named ann1_ora_11408.trc: Copy code snippet Copied to Clipboard Error...
File is in user_dump_dest specified in init.ora. To check the directory through SQL execute: SQL> select value from v$parameter where name = 'user_dump_dest'; . To execute tkprof: $ tkprof (trace file name> . Upload raw and tkprofed files. To find trace files in 11G and higher: ...
tkprof <trace_File>.trc <tkprof>.out sys=no explain=apps/<apps pwd> 2: How do you get debug log for an API when executed from a SQL script outside of Oracle Applications ? a) For Inventory APIs i. Enable INV Debug profiles at User level for the user who would be running the API...
tkprof <trace_File>.trc <tkprof>.out sys=no explain=apps/<apps pwd> 2: How do you get debug log for an API when executed from a SQL script outside of Oracle Applications ? a) For Inventory APIs i. Enable INV Debug profiles at User level for the user who would be running the API...
Oracle Sourcing - Version 11.5.10 and later Oracle Purchasing - Version 12.0.6 to 12.2 [Release 12 to 12.2] Oracle iProcurement - Version 11.5.9 to 12.2.4 [Release 11.5 to 12.2] Information in this document applies to any platform. ...
Learn how to get an execution plan in Oracle Database using SQL Developer, SQL monitor, DBMS_XPlan, or TKPROF
Oracle iProcurement - Version 11.5.9 to 12.2.4 [Release 11.5 to 12.2] Information in this document applies to any platform. iProcurement - Version: 11.5.9 to 12.0 GOAL How to get log files in iProcurement according to the Procurement/Supply Chain Family Pack level or Oracle Applications rele...