Search notes:

DBMS_SPACE_ADMIN.SEGMENT_DUMP

dbms_space_admin.segment_dump dumps the segment header and bitmap blocks of a segment.
create table tq84_space_admin_seg_dmp_tst (
   num  number,
   txt  varchar2(1000)
);

begin

   for i in 1 .. 20 loop
       insert into tq84_space_admin_seg_dmp_tst values(i, rpad('*', 1000, '*'));
   end loop;

end;
/

commit;

declare

   ts_name   varchar2(128);
   file_id   number;
   block_id  number;
   dump_file varchar2(1000);

begin

   select tablespace_name, header_file, header_block
   into   ts_name        , file_id    , block_id
   from   dba_segments
   where  segment_name = 'TQ84_SPACE_ADMIN_SEG_DMP_TST' and
          owner        =  user;

 - sys.dbms_space_admin.segment_dump(ts_name, file_id, block_id, sys.dbms_space_admin.segment_dump_extent_map    );
   sys.dbms_space_admin.segment_dump(ts_name, file_id, block_id, sys.dbms_space_admin.segment_dump_bitmap_summary);

   select value into   dump_file
   from   v$diag_info
   where  name = 'Default Trace File';

   dbms_output.put_line('  dumped block to: ' ||  dump_file);

end;
/

drop table tq84_space_admin_seg_dmp_tst;
Github repository Oracle-patterns, path: /Installed/dbms/space_admin/segment_dump/go.sql

See also

dbms_space_admin

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758207334, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/space_admin/api/segment_dump/index(84): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78