set pagesize 1000
from v$datafile d,
group by s.TABLESPACE_NAME,d.BYTES;
What is the correct way to size a database? At present I have sized it using the dbf's for the physical size. How do incorporate the logical size?
IMHO, The best method for tuning is checking fragmentation. And in some cases determinig if partitioned tables and indexes will give you speed advantage.
I have attached a script that will determine extents for you. And what you do is make sure to date stamp the report. Check for tables that have extents. Get them cleaned up. Export-Drop-Import or other method. TOAD is good for creating create table scripts. If that table comes back to haunt you again then seriously look at partitioning.