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

Home -> Community -> Usenet -> c.d.o.server -> Summery of all Used Oracle-Blocks

Summery of all Used Oracle-Blocks

From: Karl R. <kreitsch_at_zdnetmail.com>
Date: Tue, 09 Nov 1999 01:23:03 -0800
Message-ID: <000b8d9b.d39efe57@usw-ex0101-008.remarq.com>


Hello!

I am backing up with Oracle8/rman80.
Rman only backups used Oracle-Blocks.

But the statement i used for to control the backupsetsize gives the allocated segments not the used OracleBlocks, they could be less.

SELECT
  SUM(bytes) / ( 1024 * 1024 ) netto_database_size_m FROM
  dba_segments;

Do you know a statement for the exact number of used Oracle-Blocks? Thank you!

Received on Tue Nov 09 1999 - 03:23:03 CST

Original text of this message

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