x$ tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: x$ tables

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    108
    Hello,

    How can I list the entire x$ tables which are owned by SYS user?

    Thanks
    Nikee

  2. #2
    Join Date
    Feb 2000
    Location
    Brisbane, Australia
    Posts
    46

    fixed tables

    select name from v$fixed_table
    where name like 'X$%'

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