Here is the SQL script from page 886. It tells you the tablespaces that have less than 10% free space. It is a great troubleshooting script. Try running it once per day and emailing the results to yourself. I think you will find this is good way to keep an eye on your tablespace, especially when you don't have a lot of time free. It runs on Oracle database 8, 8i, 9i and 10g.
ROUND(FREE.TOTAL_FREE /TSP.TOTAL_SPACE*100) PCT_FREE,
ROUND((TSP.TOTAL_SPACE - FREE.TOTAL_FREE),2) TOT_USED,
ROUND((TSP.TOTAL_SPACE - FREE.TOTAL_FREE)/TSP.TOTAL_SPACE*100) PCT_USED,
GROUP BY TABLESPACE_NAME) TSP,
GROUP BY TABLESPACE_NAME) FREE,
GROUP BY TABLESPACE_NAME) NEXTEXT
TSP.TABLESPACE_NAME = FREE.TABLESPACE_NAME (+)
AND TSP.TABLESPACE_NAME = NEXTEXT.TABLESPACE_NAME (+)
AND ((ROUND(FREE.TOTAL_FREE/TSP.TOTAL_SPACE*100)) <> FREE.MAX_FREE);
Usability, Product Management, and LinkedIn - a rant - L inkedIn began as a professional networking site, has evolved into a social media behemoth, and has yet managed to maintain and sharpen its focus on the p...
3 weeks ago