Content-Type: text/plain; charset="us-ascii"; format=flowed
In the database the user owns it's own plan_table, which is:
Version of Oracle is 9.2.0.4.0

SQL> desc plan_table
Name                         Null?   Type
----------------------------------------- --------
----------------------------
STATEMENT_ID                          VARCHAR2(30)
TIMESTAMP                            DATE
REMARKS                             VARCHAR2(80)
OPERATION                            VARCHAR2(30)
OPTIONS                             VARCHAR2(255)
OBJECT_NODE                           VARCHAR2(128)
OBJECT_OWNER                          VARCHAR2(30)
OBJECT_NAME                           VARCHAR2(30)
OBJECT_INSTANCE                        NUMBER(38)
OBJECT_TYPE                           VARCHAR2(30)
OPTIMIZER                            VARCHAR2(255)
SEARCH_COLUMNS                         NUMBER
ID                                 NUMBER(38)
PARENT_ID                            NUMBER(38)
POSITION                             NUMBER(38)
COST                               NUMBER(38)
CARDINALITY                           NUMBER(38)
BYTES                               NUMBER(38)
OTHER_TAG                            VARCHAR2(255)
PARTITION_START                        VARCHAR2(255)
PARTITION_STOP                         VARCHAR2(255)
PARTITION_ID                          NUMBER(38)
OTHER                               LONG
DISTRIBUTION                          VARCHAR2(30)
CPU_COST                             NUMBER(38)
IO_COST                             NUMBER(38)
TEMP_SPACE                           NUMBER(38)
ACCESS_PREDICATES                       VARCHAR2(4000)
FILTER_PREDICATES                       VARCHAR2(4000)

I want to see the VPD Predicate in the SQL statement in a trace file, so I
log on as the user and do the following (based upon Pete Finnigan's "Oracle
Row Level Security: Part 2" document):

SQL> alter session set events '10730 trace name context forever';

Session altered.

SQL> set autotrace on explain

Unfortunately the result of the last is:

SP2-0613: Unable to verify PLAN_TABLE format or existence
SP2-0611: Error enabling EXPLAIN report

My DBA is at a loss. Can anyone help?

Dan


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