Hello,
Can someone tell me what are virtual tables and how they are created?
Thanks
Printable View
Hello,
Can someone tell me what are virtual tables and how they are created?
Thanks
Hi,
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.
Regards,
Rohit Nirkhe,Oracle DBA,OCP
rohitsn@altavista.com
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?
-amar
Your understanding of V_$ and V$ stuff is totaly correct.Quote:
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?
-amar
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.