Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Why is it impossibe to explain plan for virtual tables
Hi All,
Why is it impossibe to explain plan for queries with virtual tables. For example:
explain plan set statement_id='1'
for select * from sys.v_$session;
I received error:
ORA-01039: insufficient privileges on underlying objects of the view
Connected user has DBA role.
Andrew Protasov
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 17 1998 - 08:19:23 CDT