Friday, 23 May 2025

Filled under:

 SELECT

    SUM(space) * 8192 / 1024 / 1024 AS recyclebin_size_mb

FROM

    dba_recyclebin;


SELECT

    object_name,

    original_name,

    type,

    ts_name AS tablespace,

    droptime,

    space * 8192 / 1024 / 1024 AS size_mb

FROM

    dba_recyclebin

ORDER BY

    droptime DESC;


0 comments:

Post a Comment