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: [EMAIL PROTECTED] > Date: 2003/08/19 Tue PM 02:14:25 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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) > [EMAIL PROTECTED] > > > > > > <[EMAIL PROTECTED] > > > To: Multiple recipients of list > ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > > [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > > Date: 2003/08/19 Tue AM 11:19:24 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
