v$database_block_corruption

Wir hatten es mal mit korrupten Blöcken zu tun. Diese kann man so finden: — Welche Art von Corruption: col CORRUPTION_CHANGE# format 999999999999 select CORRUPTION_TYPE            , min(CORRUPTION_CHANGE#) CORRUPTION_CHANGE#           , count(*) Anz    from V$DATABASE_BLOCK_CORRUPTION   group by CORRUPTION_TYPE   order by 1 ; CORRUPTIO CORRUPTION_CHANGE#        ANZ ——— —————— ———- NOLOGGING        31880926200       1632 — […]

Alert-File über External Table auswerten

Mapping the Oracle alert log is easy and once defined, all you have to do is query it with standard SQL syntax: create directory BDUMP as   ‚/software/oracle/oracleBase/diag/rdbms/alkisrep/alkisrep/trace‘; create table    alert_log ( msg varchar2(80) ) organization external (    type oracle_loader    default directory BDUMP    access parameters (       records delimited by newline […]