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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

papalphaus (AT) yahoo (DOT) com wrote:
Exactly WHAT would you like to trace?
- - network
- - database transactions
- - forms server

Metalink has quite extensive how-to's on all subjects
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGwfcSLw8L4IAs830RArToAKCEBzCw5Slhp1XuBjrDEv XGRryRUQCfQ5vO
feu4MiBJkPLkxfrtPrXn4aE=
=eqfS
-----END PGP SIGNATURE-----

papalphaus (AT) yahoo (DOT) com wrote:
Idiot proof is impossible.

Usable by a person of average intelligence sure.

SQL>conn / as sysdba
SQL>@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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org