Re: what means this request?

From: aze <akili.zegaoui_at_atosorigin.com>
Date: 3 May 2004 08:44:34 -0700
Message-ID: <25441ae4.0405030744.6e402a7d@posting.google.com>

This request is generated by a tool of administration which I launched on oracle version 8.1.7.0, it turns over occupied and open space in a tablespace.

SELECT d.tablespace_name,
       v.name,
       v.status,
       v.enabled,


	 ' ',

	 ' ',

       to_char(round(d.bytes/b.unit,2)),
       to_char(round(d.user_bytes/b.unit,2)),
       to_char(round(s.bytes/b.unit,2)),
       to_char(round(s.bytes*100/d.bytes,2))||'%',
       ' ',
       to_char(round(s.maxbytes/b.unit,2)),
       to_char(s.num),
       v.file#
  FROM sys.dba_data_files d,
       v$datafile v,
       (SELECT file_id, NVL(SUM(bytes),0) bytes, COUNT(1) num,

NVL(MAX(bytes),0) maxbytes FROM sys.dba_free_space GROUP BY file_id) s,

       (select :unt<int> unit from sys.dual) b
 WHERE (s.file_id (+)= d.file_id)
   AND (d.file_name = v.name)

Received on Mon May 03 2004 - 10:44:34 CDT