Re: Tracing a forms session on the apps server

papalphaus_at_yahoo.com wrote:
> Can someone provide me with idiot proof instructions on how to do a
> trace on a froms session?
> My environment is:
> Forms [32 Bit] Version 10.1.2.0.2 (Production)
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
> With the Partitioning option
> JServer Release 9.2.0.7.0 - Production
> Oracle Toolkit Version 10.1.2.0.2 (Production)
> PL/SQL Version 10.1.0.4.2 (Production)
> Oracle Procedure Builder V10.1.2.0.2 - Production

Idiot proof is impossible.

Usable by a person of average intelligence sure.

SQL>conn / as sysdba
SQL>_at_c:\oracle\product\ora10\rdbms\admin\dbmssupp.sql
SQL>GRANT execute ON dbms_support TO schema_owner;
SQL>CREATE PUBLIC SYNONYM dbms_support FOR dbms_support;

SELECT DISTINCT sid FROM gv$mystat;
SELECT SYS_CONTEXT('USERENV', 'SID') FROM dual; SELECT dbms_support.mysid FROM dual;

DECLARE
  s gv$session.sid%TYPE;
  r gv$session.serial#%TYPE;
  w BOOLEAN := TRUE;
  b BOOLEAN := TRUE;
BEGIN
   SELECT sid, serial#
   INTO s, r
   FROM gv$session
   WHERE username = 'UWCLASS';

   dbms_support.start_trace_in_session(s, r, w, b); END;
/

DECLARE
  s gv$session.sid%TYPE;
BEGIN
   SELECT sid
   INTO s
   FROM gv$session
   WHERE username = 'UWCLASS';

   dbms_support.stop_trace_in_session(s, NULL); END;
/

From:
http://www.psoug.org/reference/dbms_support.html

The above assumes a username of UWCLASS. An idiot, of course, might use a different schema or fat finger in a schema name.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org