Re: Grant SYS.x$KCCCP to DBA..........................

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 - 03:27:55 CDT