a_conc_reqsch.sql

	11i: reports all pending and running requests from
	FND_CONCURRENT_REQUESTS table with details of USER
	START TIME, ARGS and PROG NAME.  Allows to limit the
	list to a certain PROGRAM.
    

a_gather.sql

	This script will analyze SCHEMA using fnd_stats.gather_schema_statistics
    

a_profile_opt_R107.sql

	Reports Profile Options For Oracle Applications
	with NOT NULL values, groups by Profile Option Name
	breaks by SITE, RESPONSIBILITY, APPLICATION, USER
	Takes Parameter Name as search string
	Allows you to view ALL possible values for profile
	including SITE, RESPONSIBILITY, APPLICATION and USER.
	This is impossible in Oracle Apps GUI mode

a_profile_opt_R11.sql

	Reports Profile Options For Oracle Applications
	with NOT NULL values, groups by Profile Option Name
	breaks by SITE, RESPONSIBILITY, APPLICATION, USER
	Takes Parameter Name as search string
	Allows you to view ALL possible values for profile
	including SITE, RESPONSIBILITY, APPLICATION and USER.
	This is impossible in Oracle Apps GUI mode

a_profile_opt_R11i.sql

	Reports Profile Options For Oracle Applications
	with NOT NULL values, groups by Profile Option Name
	breaks by SITE, RESPONSIBILITY, APPLICATION, USER
	Takes Parameter Name as search string
	Allows you to view ALL possible values for profile
	including SITE, RESPONSIBILITY, APPLICATION and USER.
	This is impossible in Oracle Apps GUI mode

a_ses_by_pid.sql

	** SHOULD BE RUN AS APPS **
	Reports the following:
	----------------------
	- session detail from v$session, v$process
	   by PID (from backend).
	- any running requests from apps.FND_CONCURRENT_REQUESTS
	   output includes REQ_ID, Phase, Status, O-PID, A-PID, OUT File
	- calls analyzereq.sql to print details of a REQ_ID
	NOTE:
	   to link request id to a session use one of the following
	      o fnd_concurrent_requests.oracle_session_id = v$session.audsid
	      o fnd_concurrent_requests.oracle_process_id = v$process.spid
	        (v$process.addr = v$session.paddr)
	      o fnd_concurrent_requests.os_process_id     = v$session.process
    

a_user_ses_R11.sql

	Displays session information
	for Oracle Applications
	!! Will only work if AUDIT is set for USER Level !!
	To do this set:
	navigator(Sys Admin Resp)
	 -Profile
	  -System
	   -Find System Profile Values (FORM)
	    search>
	    -System Profile Values (FORM)
	     save>
	+-----------------------------------------------+
	| If you dont set AUDIT level to USER           |
	| then PACKAGE APPLSYS.FND_SIGNON will not      |
	| populate table FND_LOGINS with information    |
	| about user sessions.                          |
	| HERE is that package body:                    |
	|   UPDATE FND_LOGINS FL                        |
	|   SET PID = (SELECT P.PID                     |
	|         FROM V$PROCESS P, V$SESSION S         |
	|         WHERE S.AUDSID = USERENV(`SESSIONID`) |
	|         AND S.PADDR = P.ADDR)                 |
	+-----------------------------------------------+
	This script ** MUST BE RAN as SYSTEM **

a_user_ses_R11i.sql

	Displays session information
	for Oracle Applications R11i
	!! Will only work if AUDIT is set for USER Level !!
	To do this set:
	navigator(Sys Admin Resp)
	 -Profile
	  -System
	   -Find System Profile Values (FORM)
	    search>
	    -System Profile Values (FORM)
	     save>

	WARNING:

	-------
	This script ** MUST BE RAN as SYSTEM **

	If you dont set AUDIT level to USER
	then PACKAGE APPLSYS.FND_SIGNON will not
	populate table FND_LOGINS with information
	about user sessions.
	HERE is that package body:
	   begin
	       SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID
	       INTO local_pid, local_spid, local_serial#
	       ,    local_process_spid
	       FROM V$PROCESS P, V$SESSION S
	       WHERE S.AUDSID = USERENV(`SESSIONID`)
	       AND S.PADDR = P.ADDR,
	   exception
	   when no_data_found then
	       local_pid := null,
	       local_spid := null,
	   end,

	   -- Insert record
           INSERT INTO FND_LOGINS
           (LOGIN_ID, USER_ID, START_TIME, TERMINAL_ID,
               LOGIN_NAME, PID, SPID, SESSION_NUMBER, SERIAL#,
               PROCESS_SPID, LOGIN_TYPE)
           VALUES(audit_user.login_id, audit_user.user_id, SYSDATE,
                  audit_user.terminal_id, audit_user.login_name,
                  local_pid, local_spid, audit_user.session_number,
                  local_serial#, local_process_spid, `FORM`),

a_wsesd.sql

	Allows to get details for an NCA session by OS PID.
	Use for R11i connections to trace back to the middle tier.
	This script can report session by
	either backend PID or front end PID.