Home -> Usenet -> c.d.o.server -> Identifying deleted rows for a table

Identifying deleted rows for a table

From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Mon, 18 Apr 2011 07:48:39 -0700 (PDT)
Message-ID: <56bbc456-e724-472c-b9f2-eecbd0b62f0a_at_e8g2000vbz.googlegroups.com> 





Oracle 10.2.0.4 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







regards


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












Original text of this message