Re: Re: Row level security and latch waits

Nuno,

I've seen "previous" replies appearing much later than "subsequent" replies quite many times here... Few times even my posts have got lost for good...

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 21, 2003 6:00 PM

> Interesting. I didn't get Connor's reply...
>
> Cheers
> Nuno Souto
> nsouto_at_optusnet.com.au
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, August 21, 2003 1:49 AM
>
>
> > so in 9i dbms_rls increases the soft parses?
> > >
> > > From: Connor McDonald <hamcdc_at_yahoo.co.uk>
> > > Date: 2003/08/20 Wed AM 11:21:59 EDT
> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > 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 <nsouto_at_optusnet.com.au> wrote: >
> > > ----- Original Message -----
> > > >
> > > > > - Use context values within predicates, as bind
> > > > variables <<<< NOTE THIS
> > > > > LINE.>>>>>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Nuno Souto
> INET: nsouto_at_optusnet.com.au
>
> 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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).