Oracle Applications SQL Scripts
| oa_info.sql | - | Nice script to show the physical layout of an Oracle Applications database. Includes product installations and versions (e.g. duplicates information from auto install and adutconf.sql). |
| fndlock.sql | - | This is lockmon with the Oracle Applications user added for apps account logins. |
| fndreq.sql | - | Show currently running concurrent requests |
| fndusrmap.sql | - | Maps Oracle Applications user information, similar to the Monitor Users screen. This query has been improved to handle SC/NCA users more accurately. NOTE: fndchrmap.sql has been removed and the code added as comments back into this script. |
| fnd_long.sql | - | Displays concurrent requests that have run times longer than one hour (3600 seconds) |
| fndcmmap.sql | - | This script will map concurrent manager process information about current concurrent managers. |
| fndrqmap.sql | - | This script will map concurrent request information about a specific request id. |
| fnd_cp_time.sql | - | Script to list concurrent programs by time started. |
| fnd_pgm.sql | - | Script to list concurrent programs by name and run time. |
| fnd_pgm_RP.sql | - | Script to list concurrent programs in a resource profile type format. |
| fnd_cp_ovlp_bymgr.sql | - | Script to list concurrent manager queue overlaps. |
| fnd_cm_hrly_sum.sql | - | Script to list concurrent manager utilization by hour. You are welcome to leave a comment. |
0 comments:
Post a Comment