Summary of Tablespace
The following script allows us: Used percent, free space Details and properties Segments inside tablespaces Statistics of segments Statistics of IO per datafiles Datafiles of tablespace Quotas Script: view : tbsinfo.sql download : tbsinfo.sql Example: Tablespace Name : DATACCSL02 --- Tablespaces Tablespace Size MB Free MB Used MB Used Pct ------------------------------ ---------- ---------- ---------- -------- DATACCSL02 49158 48256 902 1.83 % Status Logging Extent Man Allocation ASSM Next Extent KB Contents Block Size --------- --------- ---------- ---------- ------ -------------- --------- ---------- ONLINE LOGGING LOCAL UNIFORM AUTO 131072 PERMANENT 8192 --- Quotas User Used Quota ------------------------ ---------- --------------- UCS 896 UNLI