Re: Based of the Tablespace Growth Script I need to define a query.

Thanks for the input...I will look into in ..and see what comes out of it.

On Thu, Feb 3, 2011 at 1:28 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> Then you need to be sure your underlying data is a regular time series
> and use lag (as per Stephane’s suggestion) and pivot. If prior to 11g, look
> up how to pivot without the new pivot syntax, very well described by Tom
> Kyte; putting kyte pivot into your favorite search engine should get you
> there quickly if you skip any known bad sites. Or buy his book.
>
>
>
> mwf
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Sheldon Quinny
> *Sent:* Thursday, February 03, 2011 4:47 AM
> *To:* Mark W. Farnham
> *Cc:* Oracle-L Freelists
> *Subject:* Re: Based of the Tablespace Growth Script I need to define a
> query.
>
>
>
> Hi Mark,
>
> Thanks for the 5 para answer that really made me want to grab a coffee...
>
> First of all , this all is still on the test systems, so I would take your
> operational cost advice.
> Second off..the main idea for me is to generate a report for the increase
> in tablespace each month and email it to the management.
>
>
> The dig mention below is of what I would want ....end of the day.
>
> [image: 02.png]
>
> <snip>
>
>
>

--
http://www.freelists.org/webpage/oracle-l