Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
![]() |
![]() |