Check the Number of Rows per Block

Join this site Explore »

Oracle Database » SQL Library » Check the Number of Rows per Block

--
-- Check the Number of Rows per Block.
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
COLUMN "Rows per Block" FORMAT 9999
 
SELECT
   count(*) as "Rows per Block"
FROM
   &&tabname
WHERE
   dbms_rowid.rowid_block_number(rowid) =
     (
     SELECT
        min(dbms_rowid.rowid_block_number(rowid))
     FROM &&tabname
     )
/