-Original Message-
Sent: Wednesday, July 04, 2001 2:53 PM
To: '[EMAIL PROTECTED]'
I think you need this
comp sum of nfrags totsiz avasiz on report
break on report
col tsname format a16 justify c heading 'Tablespace'
col nfrags format 999,990 justify c heading 'Free|Frags'
ya i checked this too.. it's not working.
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 03, 2001 7:00 PM
sorry. I checked it and turned out that
Hi!
Try this.
select a.tablespace_name,sum(a.bytes),sum(b.bytes) from dba_data_files a,
dba_free_space b where b.tablespace_name=a.tablespace_name group by
a.tablespace_name
Gyula
hi gurus,
any body have any idea of how to join these querries.
i want to select from two different tables
Hi,
SELECT
ddf.tablespace_name,
ddf.total,
dfs.free
FROM
(select tablespace_name,
sum(bytes)/1024/1024 total from dba_data_files group by tablespace_name)
ddf,
(select tablespace_name,
sum(bytes)/1024/1024 free from dba_free_space group by tablespace_name)
dfs
WHERE
select a.tablespace_name, a.bytes, b.bytes
from (Select tablespace_name, sum(bytes) as bytes
from dba_data_files
group by tablespace_name) a,
(Select tablespace_name, sum(bytes) as bytes
from dba_free_space
group by tablespace_name) b
where
Use the following script
select a.tablespace_name,sum(a.bytes/1024/1024) DF ,
sum(b.bytes/1024/1024) DFS
from dba_data_files a, dba_free_space b
where a.tablespace_name = b.tablespace_name
group by a.tablespace_name
/
HTH John
-Original Message-
Sent: 03 July 01 12:46
To:
sorry. I checked it and turned out that this is wrong solution
Hi!
Try this.
select a.tablespace_name,sum(a.bytes),sum(b.bytes) from
dba_data_files a,
dba_free_space b where b.tablespace_name=a.tablespace_name group by
a.tablespace_name
Gyula
--
Please see the official ORACLE-L
Try
this,
select
a.tablespace_name,sum(a.bytes),sum(b.bytes) from dba_data_files
a,dba_free_space b where
a.tablespace_name=b.tablespace_namegroup by
a.tablespace_name;
JAIMIN.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh