Originally posted by patel_dil
1. ??

2. Query V$FIXED_TABLE for all fixed tables and fixed views.
Hi

you have helped me with qns 1 from the answer that u have given to qns 2.


SQL> select * from v$fixed_table where name='V$SESSION';

NAME OBJECT_ID TYPE TABLE_NUM
------------------------------ ---------- ----- ----------
V$SESSION 4294950919 VIEW 65537


Therefore, v$session is a fixed table view.

Cheers!

One last qns, is to find out those not fixed table views.