Re: Summery of all Used Oracle-Blocks

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 09 Nov 1999 17:46:35 +0800
Message-ID: <3827ED7B.56C4@yahoo.com>

Karl R. wrote:
>
> 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!

Check out the dbms_space package - it may give you what you are after

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Nov 09 1999 - 03:46:35 CST