Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Summery of all Used Oracle-Blocks
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!