VPD Pre/Post Implementation Issues

  • From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
  • To: <oracledba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 18 Aug 2004 22:16:32 +0530

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: