Database Corruptions V$DATABASE_BLOCK_CORRUPTION

We have the following records at V$DATABASE_BLOCK_CORRUPTION

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

 

    FILE#    BLOCK#    BLOCKS CORRUPTION_CHANGE# CORRUPTIO    CON_ID

---------- ---------- ---------- ------------------ --------- ----------

       42   4084621         1                 0 FRACTURED         0

       42   4084622         3                 0 ALL ZERO          0

       42   4084625         1                 0 FRACTURED         0

 

6 rows selected.

We run the following in order to find the objects but

SELECT DISTINCT owner, segment_name,SEGMENT_TYPE FROM v$database_block_corruption dbc JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1 ORDER BY 1,2;

no rows selected

We run the following in order to check the free space