x$k* tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: x$k* tables

  1. #1
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32
    Hi

    Can anyone say me what is the SQL file that i have to run to get the x$k* files

    Thanks in advance
    Felix
    DBA

  2. #2
    Join Date
    Oct 2000
    Posts
    80
    If you have a database, you have the x$ tables as the base tables for the data dictionary. As far as i know, these are undocumented,and are created during the create database statement. If you know the name of the table you want you can simply select from it.
    A good example would be select * from X$KTURD.
    John Doyle

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    In fact, X$ tables are not a base tables for data dictionary. Base table for data dictionary are real tables, owned by SYS, created during database creation, like OBJ$, FILE$, FET$ etc...

    X$ tables are the base "tables" for dynamyc prerformance views (V_$) and they are not real tables - they are not written anywhere in the disk, so they don't have physycal attributes (extents, storage...). AFAIK they are some kind of C constructs, residing in the memory as long as database is up and runing. Once the instance goes down they dissapear and when instance starts again they got created in the memory again.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Nov 2000
    Posts
    212
    1. open oracle binary (oracle.exe for winNT) with text editor and search for X$ entries.

    Create list of them and insert into db table.
    2. Generate and run a script to create views on them: create view V_<X$tablename> as select * from <X$tablename>. 3. Then query DBA_TAB_COLUMNS for those views.


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