MIME-Version: 1.0
References: <CAJueESpT3UG4s1z1brZ248qCH+vOYEa3CmSgsjcc=9zfK0OAnA@mail.gmail.com>
 <6fb22582-0639-8533-a754-552069bb846d@gmail.com>
In-Reply-To: <6fb22582-0639-8533-a754-552069bb846d@gmail.com>
From: Sayan Malakshinov <xt.and.r@gmail.com>
Date: Tue, 21 Dec 2021 18:39:21 +0300
Message-ID: <CAOVevU5drLSzG5XjM7y1bdHJgkk46Cqs_y4w36PKN9ivw1z47Q@mail.gmail.com>
Subject: Re: sql_trace filtering
To: Mladen Gogala <gogala.mladen@gmail.com>
Cc: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000cdef3e05d3a9cfd7"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: xt.and.r@gmail.com
--000000000000cdef3e05d3a9cfd7
Content-Type: text/plain; charset="UTF-8"

Hi Adric,

Yes, of course, for example, you can specify a filter by process: ospid or
orapid or pname:

{process:  ospid           <string>[20],
           orapid          <ub4>,
           pname           <string>[20],
           con_id          <ub8> }


http://orasql.org/2021/05/20/oracle-diagnostic-events-cheat-sheet/

http://orasql.org/files/events/doc/event/filter/oradebug-doc-event-filter-process.php


On Tue, Dec 21, 2021 at 6:30 PM Gogala, Mladen <gogala.mladen@gmail.com>
wrote:

> *CAUTION: This email has originated from an extremely suspect and
> sometimes very grumpy sender. Proceed with extreme caution and use the
> Force.*
> On 12/21/2021 10:14 AM, Adric Norris wrote:
>
> Is it possible to add a filter for user ID/name as well? I've been
> searching, but can't seem to find any examples of this if so.
>
> Thanx!
>
> Hi Adric!
>
> You can create on logon trigger for the specified user and use "ALTER
> SESSION" instead of "ALTER SYSTEM".
>
> Regards
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
> Blog: https://dbwhisperer.wordpress.com
>


-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE
http://orasql.org

--000000000000cdef3e05d3a9cfd7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi Adric,<div><br></div><div>Yes, of course, for example, =
you can specify a filter by process:=C2=A0ospid or orapid or pname:</div><d=
iv><br></div><div><pre style=3D"color:rgb(0,0,0)"><code>{process:  ospid   =
        &lt;string&gt;[20],
           orapid          &lt;ub4&gt;,
           pname           &lt;string&gt;[20],
           con_id          &lt;ub8&gt; }</code></pre></div><div><br></div><=
div><a href=3D"http://orasql.org/2021/05/20/oracle-diagnostic-events-cheat-=
sheet/">http://orasql.org/2021/05/20/oracle-diagnostic-events-cheat-sheet/<=
/a><br></div><div><br></div><div><a href=3D"http://orasql.org/files/events/=
doc/event/filter/oradebug-doc-event-filter-process.php">http://orasql.org/f=
iles/events/doc/event/filter/oradebug-doc-event-filter-process.php</a><br><=
/div><div><br></div><div><br></div></div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Tue, Dec 21, 2021 at 6:30 PM Gogala, =
Mladen &lt;<a href=3D"mailto:gogala.mladen@gmail.com">gogala.mladen@gmail.c=
om</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">
 =20
   =20
 =20
  <div>
    <p><u><b><font color=3D"blue">CAUTION: This email has originated from
            an extremely suspect and sometimes very grumpy sender.
            Proceed with extreme caution and use the Force.</font></b></u><=
br>
    </p>
    <div>On 12/21/2021 10:14 AM, Adric Norris
      wrote:<br>
    </div>
    <blockquote type=3D"cite">
      <div>Is it possible to add a filter for user ID/name as well? I&#39;v=
e
        been searching, but can&#39;t seem to find any examples of this if
        so.</div>
      <div><br>
      </div>
      <div>Thanx!</div>
    </blockquote>
    <p>Hi Adric!<br>
    </p>
    <p>You can create on logon trigger for the specified user and use
      &quot;ALTER SESSION&quot; instead of &quot;ALTER SYSTEM&quot;.</p>
    <p>Regards<br>
    </p>
    <div>-- <br>
      Mladen Gogala<br>
      Oracle DBA<br>
      Tel: (347) 321-1217<br>
      Blog: <a href=3D"https://dbwhisperer.wordpress.com" target=3D"_blank"=
>https://dbwhisperer.wordpress.com</a></div>
  </div>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
 class=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>Best=
 regards,<br>Sayan Malakshinov</div><span style=3D"font-size:13.6px">Oracle=
 performance tuning engineer</span><br style=3D"font-size:13.6px"><div>Orac=
le ACE<br><a href=3D"http://orasql.org" target=3D"_blank">http://orasql.org=
</a></div></div></div></div></div>

--000000000000cdef3e05d3a9cfd7--
--
http://www.freelists.org/webpage/oracle-l