Three solutions:
1) run query as sys
2) create view over x$kcccp and grant select on that view to the user
you want
to use to run the query.
3) create a sys owned function that returns the value you care about
from x$kcccp and grant the function.
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<412c4d86$0$2036$afc38c87_at_news.optusnet.com.au>...
> marjina98_at_hotmail.com wrote:
>
> > Thanks,
> >
> > Is creating a view on fixed tables is the only solution for my query?
> > Should the view which we created for the fixed table SYS.x$KCCCP
> > refresh implicitly?
> > By default, is there an alternative view of this fixed table
> > SYS.x$KCCCP available, if so what is that view.
> >
> > you are right I want to see the column CPODR_BNO on regular basis in
> > order to findout how much amount of redo generated in the current log
> > file.
> >
> >
> > Thanks
> >
> > Marjina
>
> I know what you want to do with it. I simply question *why* you want to do
> it that way.
>
> Of what possible benefit is it to know how full your redo logs are?
>
> I needed to know it *once*, in 6 years, because of a paper I was writing at
> the time.
>
> If we actually needed that information on a regular basis, I suspect the
> column would have been exposed in a regular V$. It hasn't been, and that
> should probably tell you something.
>
> Please re-think whatever it is you think you're setting out to achieve. It
> sounds like a deep, dark hole to me.
>
> HJR
Received on Wed Aug 25 2004 - 10:32:40 CDT
