home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #3 / NN_1993_3.iso / spool / comp / database / oracle / 2918 < prev    next >
Encoding:
Internet Message Format  |  1993-01-23  |  857 b 
  1. Path: sparky!uunet!dtix!uranus!nswc-wo.nswc.navy.mil!rlarson
  2. From: rlarson@nswc-wo.nswc.navy.mil (Ruth Larson)
  3. Newsgroups: comp.databases.oracle
  4. Subject: Re: checking for full tablespaces
  5. Message-ID: <1993Jan22.194427.7252@relay.nswc.navy.mil>
  6. Date: 22 Jan 93 19:44:27 GMT
  7. References: <19930122.061744.917@almaden.ibm.com>
  8. Sender: news@relay.nswc.navy.mil
  9. Organization: Naval Surface Warfare Center
  10. Lines: 15
  11.  
  12.  
  13. >Is there a simple query one may run to see if a tablespace is
  14. >full or almost full?  I am using Oracle V6 on AIX 3.2.
  15.  
  16. >Alan Beal         alanb@owgvm0.vnet.ibm.com
  17. >                  (607)751-2026
  18.  
  19.  
  20. select sum(blocks),count(blocks), sum(bytes),tablespace_name
  21.     from system.dba_free_space
  22.     group by tablespace_name
  23.  
  24.  
  25. This will give you the free space for all tablespaces.  The count(blocks)
  26. will give you some idea of how fragmented it is.
  27.