| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi !<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>One of our client wanted a Row Level=20
Security</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and we are about to implement using=20
DBMS_RLS.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Just wanted to know any of our friends=20
tested</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>the performance overhead of the RLS =
object=20
access.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Basically it adds an additional =
predicate=20
with</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>all your SQLs pointing to that RLS =
object=20
and</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>i think this may lead to over parsing =
in=20
the</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Shared pool (I have not =
seen/tested).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Can anybody confirm/reject =
this?</FONT></DIV><DIV><FONT face=3DArial size=3D2>(NON) OCP8i DBA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Best Regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>K Gopalakrishnan</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bangalore, INDIA</FONT></DIV>
------=_NextPart_000_01E2_01C0604D.AD30F8F0--
 |
 |