Re: Based of the Tablespace Growth Script I need to define a query.
- From: Sheldon Quinny <sheldonquinny@xxxxxxxxx>
- To: "Mark W. Farnham" <mwf@xxxxxxxx>
- Date: Thu, 3 Feb 2011 13:48:26 +0300
Hi,
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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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>
>
>
>
Other related posts: