Current block in redolog writing
                                                 Last update (2008-04-14 12:15:30)
                                                                                                                   Date added (2008-04-14 12:14:17)

Summary
The column cpodr_bno displays the current redo block number. Multiplied with the OS Block Size (usually 512), it returns the amount of bytes of redo currently written to the redo logs. Hence, this number is reset at each log switch.

k$kcccp can (together with x$kccle) be used to monitor the progress of the writing of online redo logs. Use the following query:
SELECT LE.LESEQ "Current log sequence No",
  ROUND(100*CP.CPODR_BNO/LE.LESIZ,2) "Percent Full",
  CP.CPODR_BNO "Current Block No",
  LE.LESIZ "Size of Log in Blocks"
FROM X$KCCCP CP, X$KCCLE LE
WHERE 
  LE.LESEQ =CP.CPODR_SEQ
  AND BITAND(LE.LEFLG,24)=8;

Current log sequence No Percent Full Current Block No Size of Log in Blocks
----------------------- ------------ ---------------- ---------------------
                   8380        33.36            85393                256000

Elapsed: 00:00:00.00
Other links
Redologs information
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search