The affect on performance will be highly dependant on the security functions
you write.
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
To
SELECT * FROM emp WHERE dept = 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
-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]
On Behalf Of VIVEK_SHARMA
Sent: Wednesday, August 18, 2004 11:46 AM
To: oracledba@(protected); oracle-l@(protected)
Subject: VPD Pre/Post Implementation Issues
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?
Environment:-
Oracle 9i=20
Application Hybrid in nature
Database - Large in Size a few Hundred GB High Concurrent Transactions Load
Periodic Reports Generation=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected) 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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
