so in 9i dbms_rls increases the soft parses? > > From: Connor McDonald <[EMAIL PROTECTED]> > Date: 2003/08/20 Wed AM 11:21:59 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Re: Row level security and latch waits > > My understanding was that the rls predicate was added > at parse time (hence the importance of the contexts > and avoiding things like 'sysdate') > > But also if I remember correctly, this behaviour was > changed in v9 to process the security function with > each execution (and hence probably increase the amount > of parsing going on). > > You might want to have a play the the > "_dynamic_policies" parameter (or something like that) > which can be used to revert the 8i behaviour (which > should reduce parsing to a degree) > > hth > connor > > --- Nuno Souto <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > > > > > - Use context values within predicates, as bind > > variables <<<< NOTE THIS > > > LINE.>>>>> > > > > > > None of that implies it's not appending a where > > clause like it > > was explained. > > > > It uses the context values (if that's the case) in a > > function > > which then returns a string. That string is then > > appended > > as a predicate to the original statement. That > > means the > > original statement is then re-parsed. It's the > > reason why > > you need query-rewrite enabled in FGAC. > > So, you get a lot of parsing. > > > > I don't know of any way of passing a context value > > as a true bind variable in a return string which is > > appended > > as a predicate. It certainly is not explained > > anywhere > > in the manual how to do it and I couldn't find > > anything > > in the literature and asktom either. > > > > Appreciate if anyone can explain how. > > > > A dynamically generated string is not the same as a > > bind variable. > > > > Cheers > > Nuno Souto > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Nuno Souto > > 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). > > ===== > Connor McDonald > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: [EMAIL PROTECTED] > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he > will sit in a boat and drink beer all day" > > ________________________________________________________________________ > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > 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).