Need a SQL
From: oracledba <oracledba71_at_gmail.com>
Date: Wed, 9 Jan 2013 14:54:27 -0500
Message-ID: <CA+eRr5FBMxKemTXwSfMYAvTrOpJgnFPRMaVX02F8Knxjg1mSqQ_at_mail.gmail.com>
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.
Date: Wed, 9 Jan 2013 14:54:27 -0500
Message-ID: <CA+eRr5FBMxKemTXwSfMYAvTrOpJgnFPRMaVX02F8Knxjg1mSqQ_at_mail.gmail.com>
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-lReceived on Wed Jan 09 2013 - 20:54:27 CET