ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located in North America that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Provides an API for tracing that includes access features not available with SQL_TRACE. This package is not part of the default installation and only supports database versions 7.2 through 8.0.5.
Normally I'd leave something like this out of the library but so far Oracle hasn't removed it from RDBMS/ADMIN so it keeps its place in the library.
AUTHID
DEFINER
Dependencies
DBMS_STANDARD
V$MYSTAT
V$SESSION
DBMS_SYSTEM
Documented
No
First Available
7.2
Installation
conn / as sysdba
@?/rdbms/admin/dbmssupp.sql
GRANT execute ON dbms_support TO uwclass;
CREATE PUBLIC SYNONYM dbms_support FOR dbms_support;
dbms_support.start_trace_in_session (
sid IN NUMBER,
serial IN NUMBER,
waits IN BOOLEAN DEFAULT TRUE,
binds IN BOOLEAN DEFAULT FALSE);
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';