RE: VPD Pre/Post Implementation Issues

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 19 Aug 2004 11:24:53 +0530
Message-ID: <F0CB3C9983B77E4AB4ADEFA63DAB109F0EFA4FD9@twrmsg03.ad.infosys.com>

Thanks indeed Justin for the valuable advice.

AIM - To Set Row level security using VPD on a Centralized Database

Qs What is the Affect on Database performance?

Qs Any General Benchmarks on the Affect on performance due to implementation
of VPD?

Qs What type of SQL Queries are most impacted SELCT, INSERT, DELETE, UPDATE
by VPD?

Qs Based on nature of Tables Transaction, Master, History etc Are there some
best practices to follow when creating policies?

Qs What are the major Pre/Post implementation issues?

Qs ANY GOOD LINKS, DOCS? (Already Checked metalink somewhat)

Environment:-
Oracle 9i,
Application Hybrid in nature,
Database - Large in Size a few Hundred GB, High Concurrent Transactions Load, Periodic Reports Generation.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Justin Cave Sent: Wednesday, August 18, 2004 11:58 PM To: oracle-l_at_freelists.org; oracledba_at_lazydba.com Subject: RE: VPD Pre/Post Implementation Issues

The affect on performance will be highly dependant on the security functions
you write. =20

Under the covers, all VPD is rewriting your SQL statements to add additional
clauses. If you are merely adding clauses to statements, i.e. having Oracle
transform

SELECT * FROM emp

SELECT * FROM emp WHERE dept =3D 10

For an employee in department 10, VPD will possibly improve performance. If, on the other hand, you are forcing Oracle to add in a couple of joins to
large tables, or to execute functions that perform poorly, VPD could cause
some significant problems.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Aug 19 2004 - 00:54:04 CDT