| | Display free, used and total space per tablespace in a database
Query to get tablespace information from Oracle database - total, used and free space, extents etc.
select a.tablespace_name, round(c.tbytes/1024/1024, 2) as TMB,
round(b.ubytes/1024/1024, 2) as UMB,
round((c.tbytes - b.ubytes)/1024/1024, 2) as FMB,
a.initial_extent, a.next_extent, a.max_extents, a.status, a.extent_management
from
(select tablespace_name, initial_extent, next_extent, max_extents, status, extent_management
from dba_tablespaces) ... | |  
More...
10/21/05 | | | | |
|
