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.
Received on Fri May 31 2002 - 08:28:55 CDT
