I don't know if you are going to be able to do that with a select statement.
adsm.archives & adsm.backups have the NODE_NAME, FILESPACE_NAME, HL_NAME,
LL_NAME but no info on size
adsm.occupancy has node_name, filespace_name, & some MB fields but nothing
file name specific
adsm.contents has node_name, filespace_name, file_name, file_size (stored
size) but you will find that all members of an aggregate have the size of
the aggregate listed (last time I looked)
so anyway, I don't know if what you are looking for is obtainable via
selects from an admin session.

Dwight


-----Original Message-----
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
Sent: Monday, March 17, 2003 12:43 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select statement


Hello!

I am still learning about the select statement and I wanted to make sure
that I get the syntax correct before I run it.  What I need is a select
statement that will look for all files with the following name:
/ut0/oradata/arch/*.arc and how much space it takes up on an individual
node.  Does anyone have any suggestions?  Thanks!

Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338