Re: Strange results when describing X$ table

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

"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 Mon Jun 11 2001 - 14:01:11 CDT