Re: Re: Row level security and latch waits

its just appending a where clause. its not binding it.

im not familiar with contexts. never worked with them. someone correct me if im wrong here? Could have sworn i read that somewhere.

i looked up application contexts. they appear to be handled differently.

am i wrong?
>
> From: JApplewhite_at_austin.isd.tenet.edu
> Date: 2003/08/19 Tue PM 02:14:25 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: Row level security and latch waits
>
>
> RLS doesn't use bind variables? How then does Oracle treat the Application
> Context variables that you include in the predicates generated by the
> Security Policy functions? If those aren't bind variables then I guess I
> don't know what bind variables are.
>
> Please refer me to the documentation on which your assertion is based.
>
> Thanks.
>
> Jack C. Applewhite
> Database Administrator
> Austin Independent School District
> Austin, Texas
> 512.414.9715 (wk)
> 512.935.5929 (pager)
> JApplewhite_at_austin.isd.tenet.edu
>
>
>
>
> <rgaffuri_at_cox.net
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent by: cc:
> ml-errors_at_fatcity Subject: Re: Row level security and latch waits
> .com
>
>
> 08/19/2003 10:44
> AM
> Please respond to
> ORACLE-L
>
>
>
>
>
>
> row level security doesnt use bind variables.
>
> dont know if there is a way to get it to use them. thats probably your
> problem.
> >
> > From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> > Date: 2003/08/19 Tue AM 11:19:24 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Row level security and latch waits
> >
> > hi all,
> >
> > in the latest code release, a group implemented RLS and since then
> spotlight
> > is constantly flagging 'latch waits' in the system. Yesterday the latch
> > waits were upwards of 90%.
> >
> > Most active sessions seem to run the policy function defined as part of
> RLS.
> > The worst part was all this wait was only on one node, the other node was
> > healthy.
> >
> > While we are trying to capture more information, anything else that we
> can
> > do? Any ideas? TIA
> >
> > Raj
> >
> ----------------------------------------------------------------------------
>
> > ----
> > Rajendra dot Jamadagni at nospamespn dot com
>
>
> >
> hi all,
>
>
> in the latest code release, a group implemented RLS and since then
> spotlight is constantly flagging 'latch waits' in the system. Yesterday the
> latch waits were upwards of 90%.
>
>
> Most active sessions seem to run the policy function defined as part of
> RLS. The worst part was all this wait was only on one node, the other node
> was healthy.
>
>
> While we are trying to capture more information, anything else that we can
> do? Any ideas? TIA
>
>
> Raj
> --------------------------------------------------------------------------------
>
> Rajendra dot Jamadagni at nospamespn dot com
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: JApplewhite_at_austin.isd.tenet.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).