Okay, another way, but the results are harder to interpret:
Only MAXLOGMEMBERS is available via x$kccdi.dimlmCode:select TYPE,RECORDS_TOTAL from v$controlfile_record_section; TYPE RECORDS_TOTAL ----------------- ------------- DATABASE 1 CKPT PROGRESS 1 REDO THREAD 1 REDO LOG 32 DATAFILE 254 FILENAME 319 TABLESPACE 254 RESERVED1 254 RESERVED2 1 LOG HISTORY 3598 OFFLINE RANGE 289 ARCHIVED LOG 3 BACKUP SET 303 BACKUP PIECE 508 BACKUP DATAFILE 523 BACKUP REDOLOG 79 DATAFILE COPY 509 BACKUP CORRUPTION 276 COPY CORRUPTION 303 DELETED OBJECT 101 PROXY COPY 572 RESERVED4 2024 22 rows selected.
NOTE: Contents of the x$tables are not guaranteed to stay the same between releases anyway so caution should be used when referencing them.




Reply With Quote