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:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:43 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] (717)975-8338