Re: VPD Pre/Post Implementation Issues

  • From: Mogens Nørgaard <mln@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 19 Aug 2004 10:10:55 +0200

Test the various scenarios in your environment via 10046 traces with and
without VPD, single-row stuff and multi-row stuff and bulk loads,
reports, etc. It's easy to measure that way.

VPD means overhead, of course. Whether it is too much or not for your
situation, well, it depends.

I seem to recall that the Oracle standard documentation is pretty good
on this topic. Have you read them already?

Mogens

VIVEK_SHARMA wrote:
> 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.

----------------------------------------------------------------
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: