tspuse.sql

-- 
-- Title :       tspuse.sql 
-- Description : To display tablespace size and 
--               usage of all tablespaces in
--               the database. 
-- 
-- Usage/Notes : (1) Ensure tspuse_proc.sql has 
--                   run first.
--               (2) Amend values in brackets 
--                   to adjust threshold 
--                   warning. 
-- 
-- Copyright :   ABCdba.com 2002
-- 
 
SET FEEDBACK OFF; 
 
SET SERVEROUTPUT ON SIZE 20000; 
 
EXEC TSPUSE (80); 
 
SET FEEDBACK ON;

© copyright 2001-2014 ABCdba.com | all rights reserved