Oracle Virtual tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Virtual tables

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87
    Hello,

    Can someone tell me what are virtual tables and how they are created?

    Thanks


  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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

  3. #3
    Join Date
    Mar 2001
    Posts
    314
    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

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  



Click Here to Expand Forum to Full Width