Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Summery of all Used Oracle-Blocks
dba_extents will help you?
Karl R. <kreitsch_at_zdnetmail.com> wrote in message
news:000b8d9b.d39efe57_at_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!
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Tue Nov 09 1999 - 06:17:47 CST