Re: Based of the Tablespace Growth Script I need to define a query.
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Thu, 03 Feb 2011 08:52:32 +0100
Message-ID: <4D4A5EC0.6080402_at_roughsea.com>
Sheldon,
Date: Thu, 03 Feb 2011 08:52:32 +0100
Message-ID: <4D4A5EC0.6080402_at_roughsea.com>
Sheldon,
Look for analytical functions, in particular LAG().
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
On 02/03/2011 07:04 AM, Sheldon Quinny wrote:
>
> Hi All,
>
> Based on the given output below, I am looking for a query that would
> show me each tablespaces growth per month. Based on the total
> tablespace growth.
>
> The Below output collectes statitics for each month for the tablespaces.
>
>
> DB_Hist.jpg
>
>
> Thanks in Advance..
>
> Regards,
> Sheldon.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2011 - 01:52:32 CST