| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: VPD Pre/Post Implementation Issues
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of VIVEK_SHARMA
Sent: Wednesday, August 18, 2004 11:46 AM
To: oracledba_at_lazydba.com; oracle-l_at_freelists.org
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
 |
 |