Tracing specific accounts

The 8i LOGON trigger can be used simply to enable tracing for a specific user.

create or replace
trigger demo_trace
after logon on DEMO.schema
begin
    sys.dbms_session.set_sql_trace(true);
end;
/