Message-Id: <10702.123904@fatcity.com> From: "K Gopalakrishnan" Date: Thu, 7 Dec 2000 13:00:30 +0530 Subject: Any performance impact on Row Level Security This is a multi-part message in MIME format. ------=_NextPart_000_01E2_01C0604D.AD30F8F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi ! One of our client wanted a Row Level Security and we are about to implement using DBMS_RLS. Just wanted to know any of our friends tested the performance overhead of the RLS object access. Basically it adds an additional predicate with all your SQLs pointing to that RLS object and i think this may lead to over parsing in the Shared pool (I have not seen/tested). Can anybody confirm/reject this? Best Regards, K Gopalakrishnan Bangalore, INDIA (NON) OCP8i DBA ------=_NextPart_000_01E2_01C0604D.AD30F8F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi !

One of our client wanted a Row Level=20 Security

and we are about to implement using=20 DBMS_RLS.

Just wanted to know any of our friends=20 tested

the performance overhead of the RLS = object=20 access.

Basically it adds an additional = predicate=20 with

all your SQLs pointing to that RLS = object=20 and

i think this may lead to over parsing = in=20 the

Shared pool (I have not = seen/tested).

Can anybody confirm/reject = this?

Best Regards,

K Gopalakrishnan

Bangalore, INDIA

(NON) OCP8i DBA

------=_NextPart_000_01E2_01C0604D.AD30F8F0-- _________________________________________________________