Re: Finding out used blocks in the database

Vadim
How do you do block dump to find out used blocks?
 
TIA
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
  <A title=vgorbounov_at_simplyengineering.com
  href="mailto:vgorbounov_at_simplyengineering.com">Vadim Gorbounov To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Friday, February 08, 2002 2:38
  PM
  Subject: RE: Finding out used blocks in   the database   

<FONT face=Arial color=#0000ff

  size=2>Sona,
<FONT face=Arial color=#0000ff

  size=2>AFAIK, block dump is the only way. It is not really a   query.
  Have
  a good weekend   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Sona     [mailto:sona_us_at_hotmail.com]Sent: Friday, February 08, 2002 3:41     PMTo: Multiple recipients of list ORACLE-LSubject:     Finding out used blocks in the database     Hi
    As we all know RMAN backs up only the used     blocks in the database.Was wondering if there is any way to query the     database to find out if a block is used or not so as to find out how much of     the database is currently being used ?      
    <FONT face=Arial
size=2>TIA Received on Fri Feb 08 2002 - 17:59:29 CST