How to Generate SQL Trace In OAF
来源:互联网 发布:凡科建站系统源码 编辑:程序博客网 时间:2024/04/29 08:22
1. Profile 'FND: Diagnostics' = Yes at user level.This will make 'Diagnostics' menu display.
2. Login to Personal Home Page as that user and select the 'Diagnostics' icon at the top of the page.
3. Select 'Set Trace Level' and click Go
4. Select the desired trace level and click Save
5. Write down the trace id number(s).
6. Perform the activity that you want to trace
7. Return to the 'Diagnostics' page.
8. Select `Set Trace Level' and click Go
9. Select 'Disable Trace' and click Go.
10. Write down the trace id number(s) if different.
11. Go to user_dump_dest for your database and collect the raw trace file(s) suffixes by the trace id number(s) you have recorded.
Note: you can identify the user_dump_dest directory in your environment by running the following SQL:
SQL> select name, value from v$parameter where name = 'user_dump_dest';
- How to Generate SQL Trace In OAF
- How to read a SQL Trace in PeopleSoft
- How to implement master-details in OAF?
- How to generate monkeyrunner build-in help?
- how to use autologger in reboot trace
- How to check backend SQL query from a OAF pages
- How To Use TKPROF To Trace And Analyze Sql Explan
- How to get trace file from getbfno.sql gettrcname.sql
- How to generate certificate
- How to generate DLL files by GCC in the MinGW?
- [Monkeyrunner]How to generate monkeyrunner build-in help?
- how to generate AXI VIP built-in coverage
- How to generate a random alpha-numeric string in java
- How to manually generate a Heapdump in WebSphere on Windows
- How to generate UML Diagrams from Java code in Eclipse
- How to generate FLEXIcontent SEF URLs in custom code
- How to Trace Qemu
- how to view contents of trace.txt in adb?
- nandwrite 参数
- jquery 计时器示例
- 解决NDK *** note: the mangling of 'va_list' has changed in GCC 4.4
- 随机数/MD5加密后以网页形式打开
- [转]手把手教你写专利申请书/如何申请专利
- How to Generate SQL Trace In OAF
- mke2fs 制作ext2文件系统image
- 用c#实现通用守护进程
- 在 宽带连接 情况下使用 交换机 让 多台机器 上网问题
- 使用JDI监听Java程序运行
- Sourcery CodeBech Lite安装及使用
- C#打开应用程序和指定的文件夹
- 数据库 decimal
- cocos2d-x 学习 -ios