Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Finding out used blocks in the database

RE: Finding out used blocks in the database

From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com>
Date: Fri, 08 Feb 2002 14:49:23 -0800
Message-ID: <F001.0040AEB7.20020208143852@fatcity.com>

<FONT face=Arial color=#0000ff
size=2>Sona,
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 ?
   
  TIA Received on Fri Feb 08 2002 - 16:49:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US