7 Replies Latest reply: Jan 27, 2013 11:23 PM by sb92075 RSS

    User Activity Trace

    744392
      I want to trace particular one user SQL activity in Oracle 10G database. Do You have any idea ..how to perform this ?

      Note - Not only one session / Not for all Database activity
        • 1. Re: User Activity Trace
          phaeus
          Hello,
          when you say one use? Did you mean several session with the same osuser or the same oracle user?
          Can you explain it ?

          regards
          Peter
          • 2. Re: User Activity Trace
            Solomon Yakobson
            Manas Guha wrote:
            Note - Not only one session / Not for all Database activity
            Assume you want to trace all sessions created by user XYZ. Then login as privileged user (user who can create BEFORE LOGON trigger and who is granted ALTER SESSION privilege directly, not via role) and:
            create or replace
              trigger trace_xyz_user
                after logon
                on xyz.schema
                begin
                    execute immediate 'alter session set sql_trace=true';
            end;
            /
            Now every time user XYZ logs in new sql trace is started.

            SY.
            • 3. Re: User Activity Trace
              Osama_Mustafa
              Please clarity exactly what you need ?

              you can enable audit .
              • 4. Re: User Activity Trace
                744392
                1. Only one user activity I need to track ( It may connected multiple OS / Machine).
                2. I can't apply audit bcz it is production database.
                3. Trigger is not sutiable solution here.

                Due to some performance issue..for paticular one user.. i have required.
                • 5. Re: User Activity Trace
                  sb92075
                  743136 wrote:
                  1. Only one user activity I need to track ( It may connected multiple OS / Machine).
                  2. I can't apply audit bcz it is production database.
                  3. Trigger is not sutiable solution here.

                  Due to some performance issue..for paticular one user.. i have required.
                  since you dismiss only viable options, then no solution is possible.

                  You're On Your Own (YOYO)!

                  Handle:     743136
                  Status Level:     Newbie
                  Registered:     Jan 5, 2010
                  Total Posts:     36
                  Total Questions:     12 (12 unresolved)

                  why do you waste time here when your questions NEVER get answered?
                  • 6. Re: User Activity Trace
                    744392
                    Solution is possible..need to very closer look oracle basic !!
                    • 7. Re: User Activity Trace
                      sb92075
                      743136 wrote:
                      Solution is possible..need to very closer look oracle basic !!
                      OK by me.