Re: X$ VIEWS

Doug

As others have mentioned, the numbers keep changing. That's why you probably will NEVER see a poster on this like the old Platinum data dictionary posters. They would go out of date from one point release to the next. You can at least get a list of them from v$fixed_table which I think wasn't around in 7.2 days.

Pete

Jonathan Lewis wrote:

> On 7.2, log in as sys and type:
> select * from x$kqfta;
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Doug Cowles wrote in message <38b18b44.8632977_at_news.remarq.com>...
> >I'm always game to learn more about the X$ views... always hoping
> >there's a poster out there that explains them or something.. but
> >generally not.. seems like collective experience and guesswork.
> >But anyhow.. I just reverse engineered the system objects in 7.2
> >Personal Oracle (although it's not perfect). and did a check on what
> >I could find on the X$ views. I only found 5....
> >They were...
> >x$kdxhs
> >x$kdxst
> >x$kturd
> >x$kzdos
> >x$kzsro
> >
> >Is that really it? Maybe it's time to stop being intimidated by this
> >advanced topic... Maybe in 8i there are several hundred? :)
> >No question here really other than - "Is that it? Only a handful?"
> >
> >- Dc.

Received on Fri Feb 18 2000 - 10:24:15 CST