No matter how you do it there will be impact on performance. More so if you use dynamic policies
Vs. static policies. As Mogens mentioned, docs are good, but nothing beats testing. You will soon
realize that you 'll need more indexes on the tables (that have policies enabled), than you 'd like,
but sometimes it is the only way to bring certain queries in acceptable performance limits. These
indexes will expecially be on the columns using which you 'll enforce the policies in _most_ cases.
set serveroutput on
begin
for i in 1 .. 1000
loop
dbms_output.put_line( 'Nothing beats testing in your OWN environment. ');
end loop;
end;
/
See, I told you thousand times .. 8:)
Raj
--- Mogens_N?rgaard <mln@(protected) > wrote:
> 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
=====
Best Regards
Raj
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
select mandatory_disclaimer from company_requirements;
__ ____ ____ ____ ____ ____ ______
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
