Are u asking Oracle V$ tables or temporary tables in Oracle 8i.V_$tables are dynamic tables which Oracle creates for its system wide statistics.They are dynamic in nature as there contents are changed evrytime.On this views,Oracle creates views with the name v$
Also Oracle creates X$ base tables which contain important
statistics for Oracle to run.
Originally posted by amar I thought that v_$'s are views and v$'s are corresponding public synonyms. Is my understanding wrong??
Is "Virtual Table" another name (synonym?) for views?
Your understanding of V_$ and V$ stuff is totaly correct.
And no, "Virtual Table" is not another name for views. The term "virtual tables" is often used as a synonym for "fixed tables", which are internal Oracle's table-like structures, persistent only in SGA. They are used by the Oracle server engine for various things, and except that they are not physical tables, they behave much like ordinary tables.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?