RE: Finding the actual size of a table

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Tue, 30 May 2000 14:47:50 -0500
Message-Id: <10513.107168@fatcity.com>

Here is a nice one from TUSC:

rem

---

rem SPCE_ALC.SQL
rem Allocated Space by Data Base Object rem (Excluding SYS and SYSTEM Objects)
rem
rem Developed By TUSC
rem
rem Disclaimor: Neither TUSC nor the author warrant that this source code

rem             is error-free.  If any errors are found in this source 
rem             code, please report them to TUSC at 630-960-2909. 

rem

---

--Spool $DBA_OUTPUT/spce_alc.lis
Spool spce_alc.lis

Set Arraysize 10
Set Numwidth 3
Set Wrap On
Set Verify Off
Set Recsep Off
Set Feedback Off
Set Space 1
Set Newpage 0
Set Pagesize 44
Set Linesize 120

Set Tab      Off
TTitle       Off
BTitle       Off

Clear Breaks

Column Instance New_Value _Instance NoPrint
Column Today    New_Value _Date NoPrint
Column Time     New_Value _Time NoPrint

Select Global_Name Instance, To_Char(SysDate, 'DD-MON-YYYY') Today,
       To_Char(SysDate, 'hh_mi_ss') Time

Received on Tue May 30 2000 - 14:47:50 CDT