Re: How can I calculate all used space in my storage-Pools
2000-01-21 04:46:56
Subject: |
Re: How can I calculate all used space in my storage-Pools |
From: |
Karl Weigel <kweigel AT MEMOREX-SH DOT DE> |
Date: |
Fri, 21 Jan 2000 10:46:56 +0100 |
John,
when you create columns with functions like sum() or count() you get unnamed
column headers. To avoid this, you can define your oun headers like:
select stgpool_name, sum(physical_mb) as "Physical", sum(logical_mb) as
"Logical" from occupancy group by stgpool_name
Karl
|
|
|