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

Unfortunately the columns in X$KCCCP is not exposed in any other v$ views. But this view doesn't have any information to tune. If you want to find out cpodr_bno value through some other v$ views, there is a indirect way. But checkpoint should happen only during the logswitch.
Try this,
alter system switch logfile;
alter system checkpoint;

select actual_redo_blks from v$instance_Recovery;

This will be *approximately* equal to

select cpodr_bno from x$kcccp;

But why???
Since you increasing the checkpoint interval you are actually putting your db in risk. Ofcourse with no use.

Thanks and Regards,
Satheesh Babu.S Received on Thu Aug 26 2004 - 01:33:56 CDT