Re: Strange results when describing X$ table

Samantha Hall <samanthahall_at_qwest.net> wrote in message news:<3B251577.86C2C642_at_qwest.net>...
> It may be related to the fact that the X$ tables are not TRUE tables as
> such. A lot of them are direct mappings to memory structures that Oracle
> uses. This one x$kcbwds is keeping track of the current working sets within
> the buffer cache. You only normally query these tables, if at all, as the
> SYS user, and don't think I'd recommend letting any other user access them.
>
> I'm not sure why you would be missing the column though.
>
> Regards,
> Samantha
>
>

Many thanks,

The application is Spotlight On Oracle from Quest software and is part of their setup when the application is first connected to a database. The setup creates various views based on system objects on order to obtain statistics for it's performance display. Curiously the two database that are failing to generate the views are both 8.1.7.1.2, although ther are other successful connections to databases ate the same patch set. When you take a look at the underlying definitio of x$kcbwds, it seems to link back to itself.
Very confusing.

Best regards

Fred J

>
>
> "Daniel A. Morgan" wrote:
>
> > FredJ wrote:
> >
> > > An application is failing when trying to create a view on dynamic
> > > table x$kcbwds.
> > >
> > > If I login a SYS and describe x$kcbwds I get:
> > > Name
> > > --------------
> > > ADDR
> > > INDX
> > > INST_ID
> > > SET_ID
> > > DBWR_NUM
> > > PROC_GROUP
> > > START_BUF#
> > > END_BUF#
> > > CNUM_SET
> > > FLAG
> > > CKPT_LATCH
> > > SET_LATCH
> > > NXT_REPL
> > > PRV_REPL
> > > ...
> > > ...
> > > CONGET (* this is the one to watch)
> > > PREAD
> > > PWRITE
> > > FGSDEPTH
> > > DBHDEPTH
> > >
> > > If I log in as another user with SELECT ANY TABLE privilege and
> > > describe the same table I get:
> > >
> > > Name
> > > --------------
> > > ADDR
> > > INDX
> > > INST_ID
> > > SET_ID
> > > DBWR_NUM
> > > PROC_GROUP
> > > START_BUF#
> > > END_BUF#
> > > CNUM_SET
> > > FLAG
> > > CKPT_LATCH
> > > SET_LATCH
> > > NXT_REPL
> > > PRV_REPL
> > > ...
> > > ...
> > > PREAD
> > > PWRITE
> > > FGSDEPTH
> > > DBHDEPTH
> > >
> > > The column CONGET is missing. x$kcbwds is a SYS owned SYNONYM object
> > > pointing to view x_$kcbwds. I can't see any reason why I get two
> > > different results. Can You ?
> > >
> > > Cheers,
> > >
> > > Fred J
> >
> > Look up the definition of the data source and go it it directly for what
> > you need.
> >
> > Daniel A. Morgan
Received on Tue Jun 12 2001 - 01:56:58 CDT