Oracle Virtual Private Database ( VPD ) – Monitoring Policy Predicate

When started on new fresh database Oracle 11g Release 2, there might occur following messages:

Note
—–
cpu costing is off (consider enabling it)
– Warning: basic plan statistics not available. These are only collected when:
* hint ‘gather_plan_statistics’ is used for the statement or
* parameter ‘statistics_level’ is set to ‘ALL’, at session or system

—-

To get rid of those messages on the development or testing environments, we can alter 2 system parameters:

1. exec DBMS_STATS.GATHER_SYSTEM_STATS;

2. ALTER SYSTEM set STATISTICS_LEVEL = ‘ALL’;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s