RE: Based of the Tablespace Growth Script I need to define a query.
From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 3 Feb 2011 05:28:57 -0500
Message-ID: <F72D51FF9C544DDFB4203D4ED3A78F03_at_rsiz.com>
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.
Date: Thu, 3 Feb 2011 05:28:57 -0500
Message-ID: <F72D51FF9C544DDFB4203D4ED3A78F03_at_rsiz.com>
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.
02.png
<snip>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2011 - 04:28:57 CST