Search This Blog

Total Pageviews

Thursday 14 September 2017

Object list via File and Block ID.

Oracle Object list via File and Block ID. ..


set pause on pagesize 100 linesize 300
column segment_name format a25
column segment_type format a25
select segment_name, segment_type, block_id, blocks from dba_extents where file_id = &file_no AND ( &block_value between block_id and ( block_id + blocks ) )

  

No comments:

Oracle DBA

anuj blog Archive