Re: viewing the x$ tables

mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0205310528.52d2421_at_posting.google.com>...
> yong321_at_yahoo.com (Yong Huang) wrote in message news:<b3cb12d6.0205301412.3230de30_at_posting.google.com>...
> > rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0205300957.51a1184f_at_posting.google.com>...
> > > Which priviledge do I need to view this? DBA access doesnt cut it. Ive
> > > been looking at them from the SYS account which I would prefer not to
> > > be in.
> > >
> > > Also, which data dictionary view do I use to get a list of the x$
> > > tables? DBA_OBJECTS and DBA_TABLES did not work?
> > >
> > > One other thing... does anyone really use these to do work? I find
> > > them incredibly hard to read... just learning them to improve my
> > > overall knowledge of Oracle.
> >
> > I always login as SYS to view them. I don't know why many people say
> > it's not good to stay in there as SYS. You can get a full list of them
> > from x$kqfdt and x$kqfta. Many have definitions in
> > v$fixed_view_definition. The best way to understand them is to read
> > Steve Adams' book and articles on his site, browse on Metalink, and do
> > all kinds of experiment. It's rarely necessary to rely on these tables
> > to do your daily work.
> >
> > Yong Huang
>
> I agree that "It's rarely necessary to rely on these tables
> to do your daily work." If you want to use the x$ tables from your
> DBA then just create a set of synonyms on them and generate the grants
> as sys to the DBA role.
>
> -- Mark D Powell --

Hi Mark,

no good idea, this might brake future upgrades or at least you will get invalid objects. There is absoltuley no guarantee that the x$ tables still exists.

Steve Received on Sat Jun 01 2002 - 20:14:12 CDT