home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1993 #3 / NN_1993_3.iso / spool / comp / database / oracle / 2921 < prev    next >
Encoding:
Internet Message Format  |  1993-01-23  |  637 b 
  1. Path: sparky!uunet!zaphod.mps.ohio-state.edu!rpi!uwm.edu!biosci!parc!rocksanne!sarek!rdutc
  2. From: rdutc@sarek.xerox (Ray Dutcher)
  3. Newsgroups: comp.databases.oracle
  4. Subject: Re: checking for full tablespaces
  5. Message-ID: <1993Jan22.194420.1436@spectrum.xerox.com>
  6. Date: 22 Jan 93 19:44:20 GMT
  7. References: <31794@nntp_server.ems.cdc.com>
  8. Sender: news@spectrum.xerox.com
  9. Reply-To: rdutc@sarek.xerox
  10. Organization: Sun Microsystems, Inc.
  11. Lines: 8
  12.  
  13. How about
  14.  
  15.  
  16. select fs.TABLESPACE_NAME, (sum(fs.bytes) / sum(df.bytes)) * 100 PctFull, 
  17.     count(*), max(fs.BLOCKS) max_contig
  18. from dba_free_space fs, dba_data_files df
  19. group by fs.TABLESPACE_NAME
  20. /
  21.