Re: purging recycle bin
From: <chris.brown_at_coveainsurance.co.uk>
Date: Fri, 24 Apr 2015 06:53:16 -0700 (PDT)
Message-ID: <383c699f-8acc-46d6-a0c0-b807208eb711_at_googlegroups.com>
Date: Fri, 24 Apr 2015 06:53:16 -0700 (PDT)
Message-ID: <383c699f-8acc-46d6-a0c0-b807208eb711_at_googlegroups.com>
> Thanks chaps
ps I did find the free space when enquiring at tablespace level
WITH TSQUERY AS ( SELECT /* + RULE */ df.tablespace_name "Tablespace",
df.bytes / (1024 * 1024) "Size (MB)",
SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",
Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "XXXX"
FROM dba_free_space fs,
(SELECT tablespace_name,SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) df
WHERE fs.tablespace_name (+) = df.tablespace_name
GROUP BY df.tablespace_name,df.bytes
ORDER BY 5 DESC)
SELECT * FROM TSQUERY;
--WHERE XXXX>90;
Received on Fri Apr 24 2015 - 15:53:16 CEST