Identifying deleted rows for a table

From: dba cjb <>
Date: Mon, 18 Apr 2011 07:48:39 -0700 (PDT)
Message-ID: <>

Oracle enterprise windows 2003

I am interested in finding out how much of a table is made up of deleted rows

/ just to see if there is a potential benefit for backups / operations

I have run following query

SELECT blocks as BLOCKS_USED, empty_blocks FROM dba_tables
WHERE table_name='TASK'

It shows me I have no empty blocks

Is there a query that shows me deleted rows / non-deleted rows within the used blocks for this table

My aim is to assess wether a table export / import would be beneficial for

  1. rman backups
  2. database operations

Chris B Received on Mon Apr 18 2011 - 09:48:39 CDT

Original text of this message