Re: Need a SQL

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Wed, 9 Jan 2013 15:34:16 -0500
Message-Id: <E438A700-D917-4ABC-9FD6-C5BE0BAB0D13_at_intactus.com>

You are going to need to have a process to store the information on a weekly basis to a table, then you should be able to query the table and get your information.

PL/SQL would be a great choice and you can schedule the execute of the procedure from either cron/windows scheduler or through dbms_jobs.

Bill
On Jan 9, 2013, at 2:54 PM, oracledba wrote:

> All,
> I am a newbie to Oracle.
> Can someone write a SQL to show tablespace's growth weekly like
> week1,week2,week3,week4 of each month?
> The table has the following columns and populated everyday.
>
> jobdate,srvrname,dbname,tsname,filename,allocatedspace,freespace
>
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed Jan 09 2013 - 21:34:16 CET