>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 - You really have to perform such queries from the client, as
       very little detail is available from the server, because
the details are OS-dependent.  Select queries will yield size info
in terms of Aggregates, which won't help you.

  Richard Sims, BU