-
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
-
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
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|