Re: Oracle Trace

From: Pete <prpotocko_at_gmail.com>
Date: 13 Jul 2006 04:59:38 -0700
Message-ID: <1152791978.673459.324190@p79g2000cwp.googlegroups.com>

As the user logs on then you could start tracing.
--
--
--

The Schema for the logon trigger must also have the alter session privilege.
--
Create or Replace trigger trace_test_user after logon on database begin if user like '%\_test' escape '\' then execute immediate 'alter session set timed_statistics=true'; execute immediate 'alter session set max_dump_file_size=unlimited'; execute immediate 'alter session set events ''10046 trace name context forever, level 8'''; end if; end; /

--
--
--

I hope that helps...Pete Received on Thu Jul 13 2006 - 06:59:38 CDT