Online Contents

SQL Scripts‎ > ‎A-I‎ > ‎

bh2.sql

set echo off

col f# new_value v_file_no
col b# new_value v_blk_no

define __DBA = &1

select
    dbms_utility.data_block_address_file(&__DBA) as f#,
    dbms_utility.data_block_address_block(&__DBA) as b#
from
    dual
;


@bh &v_file_no &v_blk_no


Comments