Hello,
x$kcccp shows CHECKPOINT PROGRESS RECORDS in
controlfile.
If you are interested in internals, see thread in
http://pipetalk.revealnet.com/read?63845,59
regards...
- "Terrian, Thomas"
<Thomas.Terrian_at_standardregister.com> wrote:
> Can anyone explain this?
> My understanding of sys.x_$kcccp is that it has the
> current log file
> information in it. But mine seems very old:
>
> SQL> select cpodr_seq, cpodr_bno from sys.x_$kcccp;
>
> CPODR_SEQ CPODR_BNO
> ---------- ----------
> 23904 2658
>
> 1 row selected.
>
> SQL> select sequence#, status from v$log;
>
> SEQUENCE# STATUS
> ---------- ----------------
> 23907 INACTIVE
> 23908 CURRENT
>
> 2 rows selected.
>
>
> Can anyone explain this?
>
> Thanks,
> Tom Terrian
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Terrian, Thomas
> INET: Thomas.Terrian_at_standardregister.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Danisment Gazi Unal
Web:
http://www.geocities.com/danisment
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment UNAL
INET: danisment_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Feb 06 2001 - 04:51:31 CST
