Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: VPD Pre/Post Implementation Issues

Re: VPD Pre/Post Implementation Issues

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Thu, 19 Aug 2004 10:10:55 +0200
Message-ID: <4124608F.1080801@miracleas.dk>


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_at_freelists.org 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
-----------------------------------------------------------------
Received on Thu Aug 19 2004 - 03:06:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US