Re: Segment summery views - do they exist?

From: David Crowson <zdxc0d_at_amoco.com>
Date: Fri, 1 Oct 1993 08:04:56 CDT
Message-ID: <1993Oct1.080456.21647_at_amoco.com>

In article 20684_at_amoco.com, zdxc0d_at_amoco.com (David Crowson) writes: [sqlplus stuff deleted ]
--> bytes/1024000 mbytes,

                 ^^^^^^^^^^^

yes thanks Chris pointed out that 1048576 is 1Mbyte not what I had in the script Well It's been a long week!

Also the script does only return Allocated space so if anyone knows of a SQL script that gives ACTUAL Usage per SEGMENT (I've got one for Tablespaces) then send or post a copy of it if you could.

Thanks in Advance

---
-----------------------------------------------------------------------------
David Crowson          | "Rude alert! Rude alert! An electrical fire
DBA (ORACLE V.4,5,6,7) | has knocked out my voice-recognition unicycle! Many 
Amoco Exploration      | Wurlitzers are missing from my database! Abandon shop!  
Ealing, London         | This is not a daffodil! Repeat: This is not a daffodil!"
dcrowson_at_amoco.com     | - Holly (Ship's computer on Red Dwarf)
"My views not Amoex's" |               =%^)
 

Received on Fri Oct 01 1993 - 14:04:56 CET