Tablespace Free Space and Max Size

by

Earlier, provided a small script to find the maximum growable size of a tablespace… Here is little more comprehensive script that shows more tablespace space info. Current size, growable size based on the autoextensible data files, free space, biggest chunk…All size is in MB. SELECT a.tablespace_name TSNAME,          ROUND(SUM(a.growable)/1048576) growable,      … Read more

SQL Script to find the top 50 tables by size

by

Here is a SQL to identify the top 50 tables. When I say table, it could be a table, partitioned table or materialized view. Takes into consideration the indexes defined on the table and lob segments in the table, thus gives a complete picture of the table size. When you truncate the table, this much … Read more