Sona,
AFAIK, block dump is the only way. It is not really a query.
Have a good weekend
-----Original Message-----
From: Sona [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 3:41 PM
To: Multiple recipients of list ORACLE-L
Subject: 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

Reply via email to